Hi there, does anyone know how to write the following sql equivalent with the org.hibernate.Criteria api?

select * from x where (name='john' and title='mr') or (position='executive' and opinion='conservative')

I've been running this as two separate queries and I'm finding it too inefficient. I'd like to run them as a single query, can anyone help.

Cheers, Sivan.

After reading the 'hibernate in action' manual I've found that using an Expression.disjuntion() will give me that I want.