Generating properties with sequence

djim · **Posted:** Mon Jan 19, 2004 10:09 am

Hi,

I want to generate a property for a class from a db sequence, like it can be done for the id of objects.

Is there any mean to declare this in an hibernate mapping ?

I've tried something like this :

Code:

<class name="test" table="test">
  <id name="id" column="id" type="long">
    <generator class="sequence">
      <param name="sequence">seq_test</param>
    </generator>
  </id>

  <property name="number" column="number" type="long">
    <generator class="sequence">
      <param name="sequence">my_seq</param>
    </generator>
  </property>
</class>

and, as I supposed, it doesn't work

any ideas ?

emmanuel · **Posted:** Mon Jan 19, 2004 10:27 am

It does not work. use the underlying conenctino to get the next sequence and update it for example using onSave().