Hi Folks,

I try to generate a query with hibernate criterias on a mapping with a composite-id. I set the criteria as I think it should be, but the query then returns nothing :-(

As I can see on the relevant part of my sql-statement (just the where-clause) hibernate tries to set all three values of the composite-id whereas I only set only one value of the composite-id expecting the rest of the values be treated as wildcards.

My question: How can I create a query on that composite-id with my single value and the rest of the c-id as wildcards?

Thanks for any hints!

Regards,

Christian

Hibernate version: 3.1.2

Mapping documents:
<hibernate-mapping>
<class name="com.myapp.entities.RoleValue" table="ROLE_VALUES">
<composite-id name="id" class="com.myapp.entities.RoleValueId">
<key-property name="roleId" type="long">
<column name="ROLE_ID" precision="22" scale="0" />
</key-property>
<key-property name="roleValue" type="string">
<column name="ROLE_VALUE" />
</key-property>
<key-property name="roleType" type="long">
<column name="ROLE_TYPE" precision="22" scale="0" />
</key-property>
</composite-id>
</class>
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():
Criteria roleValueCrt = session.createCriteria(RoleValue.class);
RoleValueId rvi = new RoleValueId();
rvi.setId(myRoleId);
roleValueCrt.add(Expression.eq("id", rvi));
List roleValueList = roleValueCrt.list();

Name and version of the database you are using:
Oracle 9i

The generated SQL (show_sql=true):
[...] where (this_.ROLE_ID=? and this_.ROLE_VALUE=? and this_.ROLE_TYPE=?)

Solved using Expression.sqlRestriction("id = " + myValue);

Regards,

Chris