Hi virla
try this out
1)
Insert into.....(
"accountId_sequence.NEXTVAL
"....)
i.e as accountId_sequence is defined in ur database give it in quotes !!!
or u can do this as well
2)
rs=stmt.executeQuery("select accountId_sequence.NEXTVAL from dual");
if(rs.next())
String accountId_seq=rs.getString(1);
and then ur insert stuff ...
Hope this helps u
cheers
Praful
[ March 19, 2003: Message edited by: Praful Thakare ]