Here's the question. I create dynamic classes and map them by generating configurations. I use a composite-id element for the primary key. I then would like to load a set of these objects in one go. Loading using get works fine, which leads me to think that the object mapping is correct.

My first attempt to load using criteria was to use Restrictions.in("id",listofids) where listofids is a list of the composite-id representation class. The generated SQL had the where clause below, the rest of the generated SQL looked normal.

I use Restrictions.in successfully with simple keys, so I know it normally works. It this behavior a known restriction, a known bug or a new bug?


Hibernate version:
3.1

Name and version of the database you are using:
SQL Server

The generated SQL (show_sql=true):
Simplified it generated a where clause with:

(CONTENTID,REVISIONID) in ((?,?))

i son't see the problem, for me it looks like it behaves correctly.
if you have a list of three items and not only one like now it should look like:
(CONTENTID,REVISIONID) in ((?,?), (?,?), (?,?))
i didn't test it but as much as i know this is correct.

Well perhaps this is a dialect issue, but doing a query like that in SQL Server generates an error. So, no, it isn't OK.

For example:

SELECT *
FROM RXS_CT_GENERIC
WHERE (CONTENTID, REVISIONID) IN ((335, 1), (336, 1))

causes SQL Server to complain about incorrect syntax near ','. This also happens with no values, so it looks like it doesn't like (CONTENTID,REVISIONID)

I was looking through the documentation for SQL Server and didn't see any "IN" operator example that did any sort of composite in clause. I was able to code around my problem by using a set of OR'd conditions. I don't know if there's an efficiency advantage of one over the other.

I noticed that the criteria API inserts the replacements parameters in the wrong order, this may be the problem