Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

help on transactions  RSS feed

 
Piradharsan Navaratnam
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello friedns I need to run a query and based on its results to run another query. How can I implement it. Im using mysql innodb.



[ UD: added CODE tags for better readability ]
[ August 19, 2007: Message edited by: Ulf Dittmer ]
 
Ulf Dittmer
Rancher
Posts: 42970
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You don't say what happens if you run the code, but I'm guessing that it doesn't work because there can only be a single ResultSet active per Statement. Try what happens if you use different Statement objects for rs_02 and rs_03.

In the future, please UseCodeTags when posting ocde of any length.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!