This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes SPs returning multiple resultsets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SPs returning multiple resultsets" Watch "SPs returning multiple resultsets" New topic

SPs returning multiple resultsets

Lee Sha
Ranch Hand

Joined: Nov 02, 2007
Posts: 66

My application uses a DB2 Stored proc from an another interfacing system for doing a search. The Stored proc returns two resultsets. Does anybody know how to traverse through both the resultsets and get the data.


Never tired...
SCJP SCWCD INS21 INS22 INS23 Salesforce Dev401
Lee Sha
Ranch Hand

Joined: Nov 02, 2007
Posts: 66
I got it. I used getMoreResults() on statement object.
I agree. Here's the link:
subject: SPs returning multiple resultsets
jQuery in Action, 3rd edition