CompositeID Query..

[Shridhar. Blr.]

Hi All,

I have a table [Trading Partners]

[B]BOMID -- PK
ID    -- PK[/B]
TradingPartnerType
[B]PartnerID -- PK[/B]
CompanyName1
CompanyName2
Street
HouseNumber
City
PostalCode
Country

Is the following TradingPartner.hbm.xml is correct??

<class name="TradingPartner" table="TradingPartner">
<!--
<key column="id"/>
-->
<composite-id>
<key-property name="BOMID "/>
<key-property name="KEY_ID"/>
<key-property name="TradingPartnerType"/>
<key-property name="PartnerID "/>
<key-property name="CompanyName1"/>
<key-property name="KEY_CompanyName2"/>
<key-property name="Street"/>
<key-property name="HouseNumber"/>
<key-property name="City"/>
<key-property name="PostalCode"/>
<key-property name="Country"/>
</composite-id>
</class>

Please correct me, if i somthing is missing..

Also is it necessary to have <id> element in .hbm.xml file..

<id name="id" column="uid" type="long">
<generator class="hilo"/>
</id>

I may not need a column, which is auto generated..

If its there, how can i give my own value, [unique key which i would want to generate/set] & not hibernate's <generator> node.

All the required values for each of the column will be set in code/application..

Any help would be highly appreciated..
Thanks in Advance.
/Shridhar..

[Sebastian Hennebrueder]

composite-id replaces id
but I would recommend to use an generic primary key instead of a composite id beeing composed of so many columns. Do not forget that each entity having a relation to your mapping must have each column in the mapping configuration.

You can read more about generators for primary keys in the Hibernate Reference.

Regards Sebastian