Hibernate Community • View topic - how to maintain sequence for each table in MS SQL & Orac

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

how to maintain sequence for each table in MS SQL & Orac

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

lalith

Post subject: how to maintain sequence for each table in MS SQL & Orac

Posted: Thu Aug 03, 2006 12:58 am

Newbie

Joined: Tue May 24, 2005 4:18 am
Posts: 8
Location: Hyderabad

Hi,

We are using Hibernate 3.1.x version.we have to address our DB related code to support both databases(Oracle & SQL Server).

How to maintain sequences for each table for two databases (Oracle & SQL Server).?.

We are able to give specific Oracle sequence by creating sequence for each table and also we have used unique sequence for all tables.
But we need individual sequence for each table and also it should support for all databases. Anyone please help us reg. this.

Actually i want to generate sequences for some tables.We are using both Oracle and MS SQL Server. Can we create custom sequence generator??. If any one implemented the same pls forward it to lalith.prasad@gmail.com.

Thanks in advance,
LALITH

Top

lalith

Post subject:

Posted: Wed Dec 19, 2007 3:01 am