Hi

I have the following SQL to convert to Criteria (if possible)... I have not seen any examples of this, can anyone suggest if it is possible?

Obviously, the select * from trkdba.fleet_vehicles where fleet_uuid = 394

has already been ported to Criteria... but I am not sure how to go about converting the NOT EXISTS part..

select * from trkdba.fleet_vehicles where fleet_uuid = 394 and
NOT EXISTS (select * from trkdba.fleet_vehicles_vor where
fleet_uuid = 394



Hibernate version:2.1.7

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

You can do that in H3, there are supquery examples in org.hibernate.test.criteria package and in my blog post at http://www.javablogs.com/Jump.action?id=198498