sequence oracle

cezeri · **Joined:** Mon Aug 01, 2005 3:07 am **Posts:** 10

hello,

I want Id column of table increase 1, on every insertion.
I tried to use .

<id name="id" column="id" type ="long">
<generator class="sequence">
<param name="sequence">my_seq</param>
</generator>
</id>

but it did not work.

--Do I have to use trigger for this?
--Are there any built in generetor in hibernate to increase the id colunm without using oracle sequence or trigger?

jcurry · **Posted:** Wed Aug 03, 2005 10:13 am

Your XML looks correct. I would look at the logged SQL and see if the sequence object is being referenced and go from there.

sven · **Posted:** Wed Aug 03, 2005 11:22 am

What does "but it did not work" mean?
Error message? Log file? SQL output?

By the way, of course you do not need to use a sequence or a trigger.
See http://www.hibernate.org/hib_docs/v3/re ... aration-id and below.

Best regards
Sven

ardal · **Posted:** Wed Aug 03, 2005 12:10 pm

Hi,

Just solved a similar issue on our team and we only had to execute a single statement on the oracle database, and then the native generator worked.

Map using native generator (not sequence)

Code:

<id name="historyID" type="java.lang.Integer" column="history_id">
    <generator class="native"/>
</id>

Error message we had:

Code:

14:18:43,951 ERROR [JDBCExceptionReporter] ORA-02289: sequence does not exist

Oracle statement that solved the problem

Code:

create sequence hibernate_sequence;

Hope this helps

sven · **Posted:** Wed Aug 03, 2005 12:16 pm

Well, of course you have to create a sequence.

Sequences are database objects like tables, views etc.

Code:

CREATE SEQUENCE sequencename
[INCREMENT BY value]
[START WITH value]
[{MAXVALUE value | NOMAXVALUE}]
[{MINVALUE value | NOMINVALUE}]
[{CYCLE | NOCYCLE}]
[{CACHE value | NOCACHE}];

cezeri · **Joined:** Mon Aug 01, 2005 3:07 am **Posts:** 10

Thanks for all replies..

There was some problem with the sequence in oracle..
I fixed it.

On the other hand, I liked the non-sequence ways, such as "increment".

tknous · **Joined:** Thu Jun 23, 2005 12:25 pm **Posts:** 7

Thank you for this post. There is no documentation on using the actual name "hibernate_sequence" for oracle. This fixed my problem after searching the forums for two days. Thank you again for your help.