aspose file tools
The moose likes JDBC and the fly likes SPs returning multiple resultsets Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "SPs returning multiple resultsets" Watch "SPs returning multiple resultsets" New topic
Author

SPs returning multiple resultsets

Lee Sha
Ranch Hand

Joined: Nov 02, 2007
Posts: 66
Hi,

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.

Thanks,
Lee...


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: http://aspose.com/file-tools
 
subject: SPs returning multiple resultsets
 
Similar Threads
java.sql.SQLException: Pls Help
PreparedStmt Cache ... ResultSets?
Java and Sybase nested stored procedures
wierd problem while retrieving results from ResultSet
Java and Sybase nested stored procedures