I would like use a sequence in order to get a value for a property (no primery-key). For example,

CREATE TABLE PRODUCT (
ID INTEGER NOT NULL,
SERIAL DEFAULT (nextVal of a sequence) NOT NULL,
...
PRIMERY KEY (ID)
);

When I create a product and call saveOrUpdate() method I need that serial is initialized with nextVal of a sequence. How I can do it?

Other form would be call nextVal of sequence manually, but I don't know how Can I do it?

Thanks for all in advance.

Hi,

have you taken a look at http://www.hibernate.org/hib_docs/refer ... -generated ?

Not sure that this is exactly what we need, but sounds not bad.

Regards,

Giorgi

Hi,
If you are comfortable using database triggers, here is one way.

i) mark the property as "generated"
<property name="serial" generated="insert" insert="false" update="false" />
ii) have a database trigger to populate the value into this column on insert.

That's it.
Hibernate ensures that,
i) this column is excluded from inserts and updates.
ii) a select for this property is done automatically on flush.

Further,
This issue has been discussed several times in the forum.
You can see if some of them are useful to you.

-------------------------------------------
Rate the reply if you find it helpful

Hi,

... or you might can use formula ?

See http://www.hibernate.org/hib_docs/refer ... n-property

Something like