Hibernate Community • View topic - Use of sequence without creating an entity

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Use of sequence without creating an entity

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

longbeach

Post subject: Use of sequence without creating an entity

Posted: Tue May 12, 2009 9:18 am

Newbie

Joined: Sat Aug 06, 2005 1:38 am
Posts: 4

hi,
I already have created a sequence in the database.
I want to use it to fill an ID field (auto-incremented then) of a table.
I did not create an entity for that table (i have to use a specific API to insert data into that table).

How can i get that sequence in Hibernate and use it to set the value of that ID field ?
Without using an entity that maps to that table.

thanks a lot for your help.

Top

mazhar

Post subject: Re: Use of sequence without creating an entity

Posted: Tue May 12, 2009 10:14 am

Newbie

Joined: Wed Jan 28, 2009 9:57 am
Posts: 16
Location: Leinfelden, Germany

Hi,
I hope i've understood your question correctly.
You can use a SQL query to query the sequence for values.
For example:

Code:

((Integer) HibernateUtil.getSession().createSQLQuery(SQL_QUERY_FOR_SEQUENCE_NEXTVAL)
                .uniqueResult()).intValue()

Since the sequence isin't (and can never be) a hibernate managed object, you cannot use other mechnism (HQL, etc) but SQL query for this.
Hope this helps!

Top

Page 1 of 1

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