Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Possible bug retrieving single Boolean column
Possible bug retrieving single Boolean column [message #635151] Mon, 25 October 2010 14:53 Go to previous message
Brendan Healey is currently offline Brendan Healey
Messages: 12
Registered: May 2010
Junior Member
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.
 
Read Message
Read Message
Read Message
Previous Topic:OneToOne + MySQL issue
Next Topic:Trouble converting SQL into JPQL with OUTER JOIN
Goto Forum:
  


Current Time: Tue May 21 05:17:44 EDT 2013

Powered by FUDForum. Page generated in 0.01674 seconds