wood burning stoves 2.0*
The moose likes JDBC and the fly likes CallableStatement ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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 http://www.javaranch.com/name.jsp . 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 frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
It is sorta covered in the JavaRanch Style Guide.
subject: CallableStatement ResultSet
Similar Threads
Regarding reultset in stored procedures
how to read few records at a time?
how to get data
calling a stored procedure
Callable Statement - Cursors