problem with hibernate and oracle 8i

[javadev]

hello everyone,

i am using hibernate with oracle 8i and sql-server2000

i am trying to insert value which have sequence field(identity in sql-server).

when i tries it ,it throws following an exception

org.hibernate.exception.GenericsJDBCException: could not get next sequence value

i am using <generator class="native"/>.

it works well with sql-server2000.

if any one has a idea please help me.

thanks in advance,
Javadev

[goldhouse]

you need to have sequence for it , just execute "create sequence hibernate_sequence " in the oracle prompt then it will work

[javadev]

hi goldhouse,

thanks for u r help...

i have already created sequence...
but i can`t get it.
i use following for id.
<generator class="native">
<param name="sequence">sq_hibernate_sequence</param>
</generator>

but i am confused that how i get next sequence value and how i can set it and insert into table?????

if u have an idea please help me.

thanks in advance.
javadev

[goldhouse]

You are mixing up

either

<generator class="sequence">
<param name="sequence">sq_hibernate_sequence</param>
</generator>

or
<generator class="native">
</generator>
In the second case , you need to have a sequence named 'hibernate_sequence'

[javadev]

hello goldhouse,

when i am creating hibernate_sequence it works fine.

but i have two tables with two different sequences.how i can use existing sequences for particular table.

thanks in advance.
javadev