I'm evaluating the use of hibernate on top our (ugly) legacy DB.

It's Oracle 9i with lots of tables having 2-column primary keys with one of them increased by a trigger.

Plus we use custom types to avoid errors with semantically close but different numerical values with inconsistent(sometimes overlapping) naming.

I know http://www.hibernate.org/hib_docs/v3/re ... -id-select but don't have a clue how to combine and get working

1) id + custom type
2) composite id + trigger
3) composite id + custom type + trigger

Any hint is appreciated!

Greetings,
M

Try evict and read after commit

regards

How would I?

Let's say we have a property orderId, column DB_OrderId, sequence SEQ_OrderId of the custom type OrderId with mediator OrderIdMed.

How should I write the mapping?

Can you give me an example?

The single-column PK I tackled with the friendly help of http://forum.hibernate.org/viewtopic.php?t=929341

Hi mrohrmoser,

I'm facing the same situation as you did last summer. Have you found how you can mix composite id + trigger ? How ?

Thanks in advance

Not really.
Try to either:

* use an alternate candidate key to identify the row
* duplicate the trigger logic into a DAO
* refactor the ER model