Hibernate version 2.1.7
I have two objects, and Application and a Queue
An Application can be on a Queue (i.e. an Application object has an instance of Queue on it), or not (the Queue is null on it).
I have a mapping files that link Queue to Application and vice versa
I want to do a hibernate query that counts how many Applications there are that are not on a Queue.
In SQL this is done by an EXCEPTION JOIN, e.g.
select count(*) from applicat ap exception join queue q on ap.appid = q.appid
How do I do this in Hibernate ?
(I'd post the mapping files but they are pretty big and it's more of a general question than one specific to my application), the relvant portiion of the Application one is here:
<one-to-one name="queueEntry" class="net.targetgroup.broker.queue.QueueEntry" outer-join="auto" cascade="all" />
_________________ On the information super B road
|