Hello

I have some problem in implementing one-to-many relationship.

I got a master table STYLE with STYLE_ID as primary key which maps to detail table ATTACHMENT 's column ID. ATTACHMENT table has composite key ID, ATTACHMENT_ID. Thus one style has many atttachments and distinguished by ATTACHMENT_ID for same ID or STYLE_ID of STYLE table.

When I try to fire query for retrieving attachments, it gives me error :
invalid identifier ATTACHMENT.STYLE_ID as there is no column as STYLE_ID in ATTACHEMNT table. Hibernate tries to search column same as primary key column in the "one" (here STYLLE) table in the "many" table(here ATTACHMENT). The equal columns involved in my case having different names, hence the problem.

Two classes are as follows.

<class name="Style" table="STYLE">
<id name="styleId" unsaved-value="0" >
<column name="STYLE_ID" sql-type="int(10)" not-
null="true"/>
<generator class="increment"/>
</id>
<set name="attachments" >
<key column="STYLE_ID" />
<one-to-many class="Attachment" />
</set>
</class>

<class name="Attachment" table="ATTACHMENT">
<composite-id>
<key-property name="styleId" column="ID"/>
<key-property name="attachmentId"
column="ATTACHMENT_ID" />
</composite-id>
</class>

Your help requested.

Girish Varde