Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

2 inserts - urgent

 
saquib nisar
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to insert two records into a Oracle DB, which are linked via object id's which are generated from a sequence.
So, the code would be:
Create Record1
Set Record1.Id = some sequence
Create Record2
Record2.Link = Record1.Id
But, once I have created record1 how do I know which record was created, or with which sequence?
Please help.
snisar@caluk.com
 
Brian Nice
Ranch Hand
Posts: 195
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you just run a SELECT statement to get the sequence number and store it in a variable for later use?
long sequenceNum = 0;
ResultSet rs = Statement.executeQuery("select sequence_name.nextval from dual");
if (rs.next() ) sequenceNum = rs.getLong(1);
Brian
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic