Hibernate Community • View topic - Using sequence-identity for id generation

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Using sequence-identity for id generation

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

william.d

Post subject: Using sequence-identity for id generation

Posted: Mon Oct 31, 2011 5:58 am

Newbie

Joined: Mon Oct 31, 2011 5:35 am
Posts: 2

Hi,

I'd like to use sequence identity in order to generate object keys. I tried the following configuration and it works :

Code:

@GeneratedValue(generator = "seqGenerator")
@GenericGenerator(name = "seqGenerator", strategy = "sequence-identity", parameters = @Parameter(name = "sequence", value = "my_seq"))

The problem is what I read in the Hibernate documentation :

Quote:

sequence-identity
a specialized sequence generation strategy that utilizes a database sequence for the actual value generation, but combines this with JDBC3 getGeneratedKeys to return the generated identifier value as part of the insert statement execution. This strategy is only supported on Oracle 10g drivers targeted for JDK 1.4. Comments on these insert statements are disabled due to a bug in the Oracle drivers.

Does this mean that sequence-identity should not be used ? If no, which oracle version is compatible with this feature ?

Are there any constraints on the use of this feature ?

Thanks,

William.

Top

william.d

Post subject: Re: Using sequence-identity for id generation

Posted: Thu Nov 03, 2011 9:33 am