Hibernate version: 3.0.5

I have an entity object with a property "uniqueID", and I have a list of uniqueIDs, what I would like to do is query the database and find out what uniqueIDs are NOT in the database. Is there an easy way to do this?

Thanks!

The reason I ask is I know at least one way to do it, would be to do an HQL query that binds a parameter something like "from myclass c where c.uniqueID in :myparam", then bind my list to myparam. However then I have to take the result and then remove every uniqueID from my original list that is in the results to find what ones are not in the database. And there will be a LOT of results... its something I'd ideally like to do in the database.

Thanks!

An example of what I'm trying to do would be helpful.

Parameter I want to bind to my query: (1,2,3,4,5)

Parameters held in the database: (1,2,3)

So my query is looking for 1-5, the database only has 1-3, so I want it to return the subtraction, which would be (4,5).

Any ideas?