I'm using a create SQL query that maps to a class with composite primary keys mapping to a oracle 9i database. I need it to call a max function on a particular column that's one of the composite ids.

I keep getting the error net.sf.hibernate.QueryException: No column name found for property [partyId] though my find functions work great and it doesn't give a error on the regular property elements. Is there a way to map to composite ids using this call or a fix?

ex:
createSQLQuery("select {pad}.test as {pad.test}, max({pad}.prty_id) as {pad.partyId} " +
"from MYTABLE {pad}",
"pad", MyClass.class)

w/ or w/o the max function causes the same error


Hibernate version:
2.1.7c

Mapping documents:

<class name="MyClass" table="MYTABLE">

<composite-id name="pk" class="MyPrimaryKey">
<key-property name="partyId" column="PRTY_ID" type="java.math.BigDecimal" />
</composite-id>
<property name="test" column="modified_by" />
</class>


exception that occurs:
net.sf.hibernate.QueryException: No column name found for property [partyId]
Name and version of the database you are using:
Oracle 9i

Hi,

I think your composite-id is not right. It should be something like this:

<class name="User" table="USER">
<composite-id name="userId" class="UserId">
<key-property name="userName" column="USERNAME"/>
<key-property name="organizationId" column="ORGANIZATION_ID"/>
</composite-id>
<property ...
...
</class>

Here UserId is a seperate class. Today I posted a question similar to this. But I found the solution by myself. You can see it here:

http://forum.hibernate.org/viewtopic.php?t=936801

That worked! I had already built a quick jdbc hit to handle it but this gives me some better insight into the mechanisms of composite id handling and reduces the code by half.

I'm hoping 3.0 has some better primary key handling such as mapping to the same object for multiple primary keys.