Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

[b]Hibernate version: 3.0

Hi,

I already have a id field (primary key) mapped to sequence, and there is another property need to map to another sequence in oracle, how can I do that?

The "WarrantNum" is not a primary key, but it needs to map to an oracle sequence.

I can't put the <generator> inside <property> tag, what's my option?

<property name="WarrantNum" type="long">
<column name="WARRANT_NUM" length="22" not-null="true" sql-type="NUMBER" />
</property>

Thanks.
David

Ok, I myself did not try myself. but from what i read, i can tell you that, in your mapping file change those two to composite key and give the sequence to both of them and try this option.

Please let us know the results.

srigold

Hi

I would be interested to know how you solved this issue since I am facing the same issue of mapping a non primary key (or part of composite key) i.e. a property to a sequence in Oracle. The sequence is there to preserve an order for enrties made.

One way to do it would be to make a Usertype for that property...

/Georges