File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes CallableStatement ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "CallableStatement ResultSet" Watch "CallableStatement ResultSet" New topic

CallableStatement ResultSet

Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hi folks,
I have a problem in retrieving the resultset returned by a stored procedure. I have got 2 resultsets in my procedure. I can get the first resultset. But when i try to get the 2nd result set it throws "ivalid resultset state" exception. Plese help me.
Frank Carver

Joined: Jan 07, 1999
Posts: 6920
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.

Read about me at ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
I agree. Here's the link:
subject: CallableStatement ResultSet
It's not a secret anymore!