hi all:

i use the following query in JPQL to query the people whose address column 
is empty.

List rl = em.createQuery( "select o from Person as o where o.address IS 
NULL" ).setMaxResults( 50).getResultList(); ...

this line of code always return an empty list, obviously the table does has 
entries that match the condition.

class Person { Address address; String name; ... } class Address { String 
name; ... }

anyone knows what's wrong with this jpql statement? thanks in advance.


by the way, the address has annotation like below:

 @ManyToOne( fetch = FetchType.EAGER,cascade = { CascadeType.PERSIST, 
CascadeType.MERGE } ) 

 @Column( name = "AddressID" ) 

  private Address address; 




-- 
You received this message because you are subscribed to the Google Groups 
"Google Web Toolkit" group.
To post to this group, send email to google-web-tool...@googlegroups.com.
To unsubscribe from this group, send email to 
google-web-toolkit+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-web-toolkit?hl=en.

Reply via email to