Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Resultsets nested within resultsets?

 
shaf maff
Ranch Hand
Posts: 180
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Guys,

Due to the nature of how my system works, one way to overcome many of the problems was to use a resultset within a resultset. At the time it seemed fine but now I have realised that the main resultset will only go through one record even if there are several records in the database. When I comment out the two nested resultsets the main rs goes through all the records fine. So I am in need of some help, do I need to fix afew things here and there or do I need to restructure the whole code (gulp) ?! Comments most welcome:

 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds like you have problem with your DB class or your method DB.exQuery() .

Since you have not posted the code of DB class only thing I can guess is you are sharing the statement/Resultset across multiple calls and you loosing reference of previous resultset.

Could you post the code of DB class.

Thanks,
Shailesh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic