When using db2 sequences, the SYSIBM.SYSDUMMY1 table should be
used (one row table, same as DUAL in Oracle).

SequenceKeyGenerator diff :

src/main/org/exolab/castor/jdo/drivers/SequenceKeyGenerator.java
176c176
<                 stmt = conn.prepareStatement("SELECT nextval FOR \"" +
seqName + "\" FROM " + table);
---
>                 stmt = conn.prepareStatement("SELECT nextval FOR " + seqName + " 
>FROM SYSIBM.SYSDUMMY1");

I submitted this in bugzilla (Bug 972)

-- 
Mickael Guessant

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to