Returning a sequence id

[Andrew Mcmurray]

Hi all

I am using JDBC to insert a row into a table and the id for that row is created using a sequence. Is there any way to get that sequence number right after you execute or a way to have that value returned.

Thanks,

AMD

[Rajasekar Elango]

Hi Andrew,

Which database are you using..? For informix, you can do something like this.

PreparedStatement ps;
...
...
ps.execute();
Long id =((IfmxStatement)ps).getSerial();

Check your jdbc provider API, there might be something similar to this. Since this is database dependent, it is not part of standard JDBC API and beware you will lose portability if you use this.

Thanks,
Raja

[Andrew Mcmurray]

Sorry I am using Oracle 10.2. I am trying select seq.nextVal from dual now and it seems to be working. Is this method thread safe?

Thanks,

AMD

[Jan Cumps]

.. sequence.nextval ... Is this method thread safe?

Yes. Oracle guarantees a unique id.

Regards, Jan