GeeCON Prague 2014*
The moose likes JDBC and the fly likes pls tell how use sequence number Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "pls tell how use sequence number" Watch "pls tell how use sequence number" New topic
Author

pls tell how use sequence number

subbareddy nallamala
Greenhorn

Joined: Mar 08, 2006
Posts: 4
i am generated one sequesnce in oracle,
but i want to use the sequence with the prpared statemebt objects
i am using type4 driver
pls tell the procedyre how to do by using java preparedStatement


Thanks in advance
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Simply use YOUR_SEQUENCE.NEXTVAL in you query


Thanks,
Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
GeeCON Prague 2014
 
subject: pls tell how use sequence number