Hibernate does not generate the primary key based on the Oracle sequence specified in the mapping file. The sql shows Hibernate is reading the nextval of the sequence, but the database primary column is not the same value. Is it a bug?

Here is some detailed information:

1) I use hibernate-2.1rc1.zip

2) my mapping:

<id
name="userCompanyId"
type="long"
column="USER_COMPANY_ID"
unsaved-value="0"
>
<generator class="sequence">
<param name="sequence">SQ_USER_COMPANY</param>
</generator>
</id>

3) sql shows:

Hibernate: select SQ_USER_COMPANY.nextval from dual
userCompanyId = 9
Hibernate: insert into USER_COMPANY (DESCRIPTION, IS_PROVIDER, ABBREVIATION, ROW_VERSION, UPDATED_BY, UPDATED_DT, USER_COMPANY_ID) values (?, ?, ?, ?, ?, ?, ?)

4) database value is: 3.7E-51 for USER_COMPANY_ID (NUMBER(15), not 9

What is going on there? any help will be greatly appreciated?

There was similar problem recently: http://forum.hibernate.org/viewtopic.php?t=925469

(At leasy I think it is similar:)

I saw many peoples with the same problem, I'm having this problem, but it stills without solution.

I use Oracle 9i and my sequences work well.
Try to use the lasest JDBC driver from Oracle.

I use Oracle 9i and my sequences work well.
Try to use the lasest JDBC driver from Oracle.
I use Integer for my keys and not long maybe there is a bug with primitive type.

I use Oracle 8i, java.lang.Long in the primary keys and ojdbc14.jar. All right?

Hi all,

I need help because I have a problem with an oracle sequence. I answered to this post to help "jhcadr" but today I have this strange problem and I don't understand why.

So I try to explain my problem. I use Hibernate 2.1.4, BEA 8.1 SP2 and Oracle 8.
I try different version of Oracle drivers but it's always the same result.
When the select XX_SQ.nextval from dual, I have the right number in log but when the insert is done I have a result like this 1,45112E.

I don't know why if it's a driver probem, an hibernat problem with Oracle dialect.

I worked on different project with Hibernate but it's the first time I have this. Last month I use the same Oracle server but on another schema and it's work well. The only difference today is that I have an Integer on the TABLE definition and usually it's an Oracle NUMBER.

If someone have an idea please help :+)

Kind regards

I think I have found the solution for this problem.
With Oracle it seems we must use a NUMBER in database schema and increment it with a sequence (not Integer, long or other exotic type).