Hibernate Community • View topic - Intializing sequences

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Intializing sequences

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

david.durham

Post subject: Intializing sequences

Posted: Thu Jun 09, 2005 1:26 pm

Newbie

Joined: Tue Apr 12, 2005 6:00 pm
Posts: 4

I'd like to use a sequence generator with oracle. Problem is that I insert some data with DBUnit in order to pre-populate the database. These inserts don't use the sequences. So, I'd like to be able to tell Hibernate to use a sequence that starts at a certain number, e.g., 50.

Any way to do this?

Top

thhart

Post subject:

Posted: Thu Jun 09, 2005 1:46 pm

Regular

Joined: Sun Aug 01, 2004 6:49 pm
Posts: 76

Do this in your database setup script/schema:

Code:

ALTER SEQUENCE "SEQUENCE_NAME" INCREMENT BY 5;

I think there is no property for this, the only I know is:

Code:

<generator class="native">
    <param name="sequence">SEQUENCE_NAME</param>
</generator>

HTH
Thomas

Top

javapda

Post subject:

Posted: Fri Jun 10, 2005 1:08 pm

Newbie

Joined: Thu Nov 18, 2004 6:51 pm
Posts: 10
Location: Arizona

Try this:

Code:

<generator class="native">
    <param name="sequence">SEQUENCE_NAME</param>
    <param name="parameters">INCREMENT BY 5</param>
</generator> 

Look at the javadoc for SequenceGenerator.PARAMETERS:

Quote:

The parameters parameter, appended to the create sequence DDL.

Hope that helps,

John

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum