How to use Oracle sequence in preparedstatement

[Sidhu roy]

String str="insert into table1 values(?,?)";
ps=con.prepareStatement(str);
ps.setInt(1,id);

now i want to insert sequence value int the second column of the table by using sequence.nextval , i did it using Statement but i want to do it with preparedstatement please help me

[Martin Vajsar]

You'll do it the same with PreparedStatement as you did with a Statement. There is no difference. The sequence is a database object, not a variable, therefore you don't use a parameter (bind variable) to specify it.

[James Boswell]

 String str="insert into table1 values(?,SEQUENCE_NAME.nextval);
ps=con.prepareStatement(str); 
ps.setInt(1,id);

replacing SEQUENCE_NAME with the name of your sequence.

[Wendy Gibbons]

hi Sidhu, please read this little item sqlColumnLists

[Sidhu roy]

thanks James Boswell and everyone, its working.