Re: how to insert sequence value using prepared statement

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 03 Nov 2004 17:54:19 GMT
Message-ID: <fX8id.32984$hN1.24310@twister.socal.rr.com>

db2group88_at_yahoo.com wrote:

> I am using oracle db server 10g on windows 2000 platform, the
> application use jdbc connection, all of the tables has a column named
> id, i would like to use sequence to insert the value to this column,
> as i know, you can insert sequence_name.nextvalu to this column for
> each insert row, but if our insert statement use prepared statement,
> how to prepare this column to insert sequence value? thanks

Just put the sequence_name.nextval in the text portion of the sql statement, you don't need to do a setXXX() with it.

--
Richard Kuhler

Received on Wed Nov 03 2004 - 11:54:19 CST