Here's my code:


Example exampleClient = Example.create( client )
.ignoreCase()
.enableLike( MatchMode.ANYWHERE );

If client.firstName has a value for 'Frank' and client.lastName has a value of 'Tyler' the resulting where clause generated by Hibernate is something like this:

where (lower(this_1_.firstName) like ? and lower(this_1_.lastName) like ?) limit ?

I would like a way to have the where clause generated as

where (lower(this_1_.firstName) like ? or lower(this_1_.lastName) like ?) limit ?

I can't figure out based on the reference documentation, the api documentation, or even Hibernate In Action as to how I can accomplish this using QBE. Any ideas?

Thanks in advanced..


Hibernate 2.1.6
MySQL

use Disjunction.add(Expression).add(Expression)