Hibernate version: 2.1

Is there a way to cache Identifier for INSERT since SequenceGenerator requires two SQL queries to insert a new object.

Anybody has suggestions on how to use "sequence.nextVal". Will "sequence.nextVal" work if I am inserting graph of objects where objects are related by id's?

Alternate solution:
Although it is very easy to write custom CacheSequenceGenerator which extends net.sf.hibernate.id.SequenceGenerator but still sequence.nextval seems better solution.

Alternate solution:
Can use "before-insert" triggers but do not want to write lot of triggers.

Alternate solution:
Can't use Native-SQL.

I do not need returned identifier which hibernate returns when INSERT is executed.

Thanks
Manish Singla

Use the sequence hilo generator

Thanks...I tested "sequence hilo generator" and it solved my problem.

QUESTION

In hibernate documentaion following is written below seqhilo.
What does it means??

"Unfortunately, you can't use hilo when supplying your own Connection to Hibernate, or when Hibernate is using an application server datasource to obtain connections enlisted with JTA. Hibernate must be able to fetch the "hi" value in a new transaction."

http://www.hibernate.org/hib_docs/refer ... on-id-hilo

We are using application server datasource enlisted with JTA.

The problem is due to Tx, but a sequence is by design outside the Tx scope. So this warn does not apply to you.