Hi, this is a funny one, when the value of the testBoolean
column for row "testuser" is false this named query
works ok, when it's true I get NoResultException. A bug?
@NamedQuery(name = "User.Test", query = "SELECT u.testBoolean FROM User u WHERE u.userName = ?1"),
...
@Column(name = "testBoolean")
private Boolean testBoolean = false;
Query query = em.createNamedQuery("User.Test");
query.setParameter(1, "testuser");
try {
result = (Boolean) query.getSingleResult();
} catch (NoResultException e) {
result = null;
}
EclipseLink, version: Eclipse Persistence Services - 2.0.1.v20100213-r6600
MySql 5.1.50-community
Regards,
Brendan.