Hello,

I'm trying to fetch nextval from a DB2-Sequence.
Hbernate-Mapping looks like this:




When executimng I'm getting the error message:


In Toad for DB2 it works.

What is wrong ?

Thanx,
NoLa

[/code]

our setup is different, you may want to try this instead. We have our auto-increments set up in the hibernate mapping files. When we execute an INSERT, Hibernate automatically figures out the next key and uses it:

In the classxxx.hbm.xml file, we have:

When executing an insert, Hibernates generates the following SQL:

select SOC_PATIENT_ID_SEQ.nextval from dual
insert into SOC_PATIENT (..., soc_patient_id,...) values (...)