Manage Hibernate Generator Sequence

Question

I need help related to Hibernate Generator Sequence.

Is it possible to manage with Hibernate java class a sequence defined in DB (Oracle) mapped by hibernate hbm file ?

I mean, update the sequence manually from java mapped class to generate a composite sequence.

Thanks !

What do you mean when you say "update the sequence"? Update is not applicable to sequences, at least not in Oracle. — Olaf
– Olaf, Commented Jun 16, 2011 at 12:52
Sorry, update the sequence, I mean to use the sequence (next, current, etc... ) defined in oracle DB via hibernate. It's possible to map a sequence (annotations, hbm.xml... ), without any relation to an POJO (in hibernate cfg file for example), and use it wherever I need ? thanks — Ricardo García
– Ricardo García, Commented Jun 17, 2011 at 6:18

Community · Accepted Answer · 2017-05-23 11:55:38Z

1

To access a sequence via Hibernate you can use a named query. For example, consider following links: define named query in orm.xml with jpa and hibernate and http://www.coderanch.com/t/218082/ORM/java/Getting-sequence-hibernate .

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Jun 17, 2011 at 13:42

Olaf

6,2991 gold badge21 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ricardo García Over a year ago

hi! I've tried this workaround and it worked as I want. This is what I finally did: 1. Create de query in *.hbm.xml mapping file from Entity: <sql-query name="nextSequenceValue"> <![CDATA[ SELECT sec_new_sequence.nextVal FROM dual ]]> </sql-query> 2. Execute the query in java code: Query query = getSession().getNamedQuery("nextSequenceValue"); It control the sequence as a wrapper to manage in java. Thanks!

Collectives™ on Stack Overflow

Manage Hibernate Generator Sequence

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related