aspose file tools*
The moose likes JDBC and the fly likes how to handle when procedure returns more than one resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to handle when procedure returns more than one resultset" Watch "how to handle when procedure returns more than one resultset" New topic
Author

how to handle when procedure returns more than one resultset

Praveen palukuri
Ranch Hand

Joined: Feb 10, 2005
Posts: 65
hi,
can we handle when a procedure returns more than one resultset.if so, please help me.

Thank u.
Evgeniy Bulanov
Greenhorn

Joined: Dec 19, 2005
Posts: 23
and what's a problem? just register more than one output parameters. And execute the procedure ...


Computers are like air conditioners - They stop working properly when you open Windows
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

I think your asking about multiple result sets, not multiple columns in a single result set.

In that case, you have to make sure the database/driver support this fluidly. If so, you can use getMoreResults() and getResultSet() to iterate through additional results sets.

I refer you to the following IBM article:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.java/bjnkmstr31.htm

Which states:

[ December 19, 2005: Message edited by: Scott Selikoff ]

My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to handle when procedure returns more than one resultset