Just jumped into Hibernate - following is a typical newbie question

software used:
latest version of hibernate
Oracle 9i database
jdk 1.4

I have a table called
txn_log
transaction_id number pk
status_cd varchar2(5) pk
message clob
.....etc

I would like to know what settings need to be done in the mapping xml file for this table to support this composite primary key? I went through some examples which shows how to deal with tables with just one field as primary key where the primary key is an auto increment in oracle.

Any sample snippet of the xml, tips, pointers etc would be helpful.

Thanks
Pradeep

Section 5.1.5 in the reference manual deals with this:

http://www.hibernate.org/hib_docs/refer ... ompositeid

below information is posted in Hibernate Users FAQ - Advanced Problems
This addresses my requirement.

I have a composite key where one column holds a generated value - how can I get Hibernate to generate and assign the value?

We regard this as an extremely strange thing to want to do. If you have a generated surrogate key, why not just make it be the primary key?

However, if you must do this, you can do it by writing a CompositeUserType for the composite identifier class, and then defining a custom IdentifierGenerator that populates the generated value into the composite key class.

Thanks

any luck with the prob

i am having the same problem