Re: JDBC: Support for multiple result sets from stored procedures

[Mark Matthews]

roger wrote:
> Hi,
>
> We are trying the stored procedure support in
> 5.0.10-beta-standard and have problems getting all
> result sets produced by the SP via JDBC. Only the
> first result set seems to be available. Are there
> any issues in this area?
>
> We've verified our code with Sybase ASE and SQL
> Server and both returns multiple result sets
> properly.
>

Roger,

This functionality is known to work, it's even in the testsuite (which gets run on every check-in and before every release).

Since you didn't post your java code, I don't know if the issue is there, but you might want to check out the actual test we use. It's in testsuite/simple/CallableStatementTest.java, and the method is testResultSet().

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html