ID generated by trigger with composite natural key

cmoranx · **Joined:** Thu Aug 25, 2005 9:34 am **Posts:** 1

Is it possible to have an ID generated by a trigger and retrieved with a select by a composite key? I assume the mapping would be like this, is it correct?

Code:

<id name="id" type="long" column="person_id">
        <generator class="select">
                <param name="key">driversLicenseIssuer</param>
                <param name="key">driversLicenseNumber</param>
        </generator>
</id>

kgignatyev · **Posted:** Thu Aug 25, 2005 11:36 am

It is not going to work.
SelectGenerator class expects just one 'key' parameter. Therefore you may need to write your own extended select generator, take a glance at org.hibernate.id.SelectGenerator for an inspiration.