Hibernate Ids

[<tony.richardson@xxxxxxxxxxxx>]

Just want to make sure I'm clear no this before I try to sell the boss on it. I 
know for sure there is no way I'll be allowed to add a "id" field to our 
databases due to the number of logical files and the mass rpg recompiles it 
would cause.

We are in the import/export business, and the majority of our databases are 
keyed with a composite key of company, branch, division, year,  file number, 
and file number suffix.  So you guys fell it's is possible to set a  
<composite-id/> field in this situation with no modification to the existing 
databases. 



Thanks,
Tony


-----------

Tony,

The usual thing to do would be to define the Hibernate ID as per the 
existing primary key on the tables.  You can use <composite-id/> if you 
have several primary key columns.

Creating a separate column for a Hibernate ID would be possible in theory, 
but very unusual!

We are using Hibernate (against a copy of some iSeries tables propagated 
to an Oracle database) and it works well.   We haven't used it to talk to 
iSeries DB/2 yet.



Niall