Has anyone else had issue with Hibernate & Oracle 8i sequences? (We run 8i because our client does). Most of the time our sequences work fine defined as shown below:

CREATE SEQUENCE STATE_ID
INCREMENT BY 1
START WITH 1
MINVALUE 1
MAXVALUE 214748647
ORDER

At one time the client DBA created the sequences with no minimum, no maximum and no order, which was a real mess. That is why we set them explicitly now.

The problem is that occasionally when we set up a new Oracle DB the limits seem to be ignored. The last time this happened I corrected the problem by restarting Oracle. In my newest created environment at home I am getting IDs like: -1.000E+64, 8.3000E+83, 8.5000E+59. When I SELECT * FROM USER_SEQUENCES is see that LAST_NUMBER is 21, not the huge exponential number shown above.

Any ideas what causes this behavior?

I am using Hibernate to get the last value of Oracle 8i sequence and I do not encounter problems like you have mentioned.

The statement I use id "select sequence_name.nextval from dual". Give this a try please.

The SQL was all correct. It was generated by Hiberante & Xdoclet using the generator-class. In the SQL log we could see that the correct sequence number was in the Insert statement, and we could also see the correct sequence number in the ID field of the object.

In the end, I think the problem was cause by using OracleDialect with the Oracle 9i driver. One of the developers had both the 9i and 8i drivers in their classpath. Once that was fixed the problem went away.

Hi Stevem/kk,

How can you guys access the oracle sequence from hibernate. I only want to get the nextval from the sequence.

thanks,

Have a look at the dialect and id packages in the src code.

I'm having the same problem. Any news about?

I'm having the same problem. Any news about?

Same solution