Hi,
I used <generator class="select"> (database triggered primary key) with one param element. This worked but I need more than one to define a unique key.
It is possible to define more than one key in <generator class="select">?
I tried several mappings but nothing worked for instance:
Code:
<id name="id" type="long" column="GAMENR">
<generator class="select">
<param name="key">from</param>
<param name="key">until</param>
<param name="key">personID</param>
</generator></id>
Only the last <key> element will be used.
If I save a game Hibernate should after the insert do a select with the following where clause:
Code:
WHERE from="2006-01-01" AND until="2006-01-10" AND personID=541
Thanks,
Detlev
Hibernate version: 3.1.3