Hibernate Community • View topic - using sequence generator without id

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

using sequence generator without id

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

zulu99

Post subject: using sequence generator without id

Posted: Wed May 30, 2007 3:22 am

Newbie

Joined: Tue Jan 31, 2006 8:00 am
Posts: 14

Hi All

I have a table which already has a composite key id.
Now i have a column in this table which is not part of the composite key.
I want to populate this column via a sequence generator. In this regard I would like to know how to use a sequence generator on a column without making it a primary key Id.

Do post your thoughts on the same

Regards,

Top

david

Post subject:

Posted: Wed May 30, 2007 9:40 pm

Hibernate Team

Joined: Tue Aug 26, 2003 7:19 pm
Posts: 2364
Location: Brisbane, Australia

Several options but the most obvious one is to use a DB Trigger and set the property to be read only.

Top

zulu99

Post subject: sequence for non - id columns

Posted: Mon Jun 04, 2007 6:21 am

Newbie

Joined: Tue Jan 31, 2006 8:00 am
Posts: 14

Hey David,

Currently we are using the trigger appraoch. What we wanted to know is if this can be taken care at the Hibernate level.

Regards

Top

david

Post subject:

Posted: Mon Jun 04, 2007 8:55 pm

Hibernate Team

Joined: Tue Aug 26, 2003 7:19 pm
Posts: 2364
Location: Brisbane, Australia

What you are doing is the best approach. Stay with it - nothing wrong with using the power of the database.

Top

Page 1 of 1

[ 4 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