File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Using Sequence to populate ID(SOLVED) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Using Sequence to populate ID(SOLVED)" Watch "Using Sequence to populate ID(SOLVED)" New topic
Author

Using Sequence to populate ID(SOLVED)

Matt Kohanek
Village Idiot
Ranch Hand

Joined: Apr 04, 2009
Posts: 483

I have never used sequences in pl sql before, so I am just wondering if it is best practice to use seq.nextval or seq.currval?

I do not know if using .currval will use the current number, and then the next time it is used ti will use the next number in line, or if .currval will keep using the same number over and over again.

Thanks for any advice

edit - I know I can easily answer this question by testing it out, but I am also looking for any best practice tips for using sequences since I have never used one.


True wisdom is in knowing you know nothing - Socrates
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2476
    
    7

you have to use nextval to retrieve the unique sequence value.

After that, curval will return the value created by that nextval call.

curval only works after you have called nextval.


OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using Sequence to populate ID(SOLVED)
 
Similar Threads
Porting to MaxDB
hibernate_sequence does exists ERROR
java.lang.outOfMemory when rendering large PDF
inserting a sequence value to the table
Escaping Characters in SQL Queries