I've a little problem with a SELECT query on a composite field ( is the table primary key too). The field is like the following on hibernate mapping file

......
<composite-id name="Id" class="MyClass">
<key-property
name="Field1"
column="COLUMN1"
type="string"
/>
<key-property
name="Field2"
column="COLUMN2"
type="string"
/>
</composite-id>
.....

The query that i'm using is

SELECT a FROM MyObject a WHERE a.Field1 = :username and a.Field2 = :pwd

and the hibernate exception is

could not resolve property: Field2 of:
MyClass [SELECT a FROM MyClass a WHERE a.Field1 = :username and a.Field2 = :pwd]


I tried to execute query with other fields ( single fields ) and i don't have problems..... So how can i do this ?

Thanx

Try adding the composite name to the path, eg:-



Hope that helps.
Cheers,
rich.

Thanx a lot !! It works....