Multiple sequence columns

rtadi · **Joined:** Tue Nov 04, 2003 4:20 pm **Posts:** 13

Hi -
I have a column other than the primary key which gets populated by a sequence. How do I set up the mapping to do that. In brief,

Code:

<hibernate-mapping>
<class name="test.foo" table="Types">
<id column="ID" name="id" type="java.lang.Integer">
<generator class="sequence">
<param name="sequence">TYPES_SEQ</param>
</generator>
</id>

<property column="ALTERNATE_ID" type="java.lang.Integer" />
</class>
</hibernate-mapping>

Incase I have a sequence called Altermate_Seq, how do I use that for the column Alternate_Id

Thanks-

emmanuel · **Posted:** Wed Jan 21, 2004 12:31 pm

You can't, but you're not the first to ask. Check JIRA and if it's not in, add it as an improvement.
For now, get the sequence number using the underlying SQL connection.