Does the query without where clause return anything?
On Dec 22, 7:24 pm, Mike <gsun...@gmail.com> wrote:
> 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.
