WebSphere Application Server - Re: WSJdbcCallableStatement and multiple result sets / Is it a bug?

Author

Re: WSJdbcCallableStatement and multiple result sets / Is it a bug?

Dmitry Domnin

2005-05-17, 6:01 pm

I decompiled rsadapterspi.jar (WAS 5.0) and it seems to be a bug there.
WSJdbcStatement class closes ResultSet in getMoreResults() before
forwarding
call to DB2 JDBC driver. But it requires the ResultSet to be open
otherwise
it cannot return the next ResultSet.

That means we cannot use WAS DataSource implementation with stored
procedures returning multiple result sets.

Any suggestions?

"Dmitry Domnin" <Dmitry.Y.Domnin@mail.sprint.com> wrote in message
news:d6ajap$24va$1@news.boulder.ibm.com...
>I can get only first ResultSet from a stored procedure when I use WebSphere
>connection pooling.
> Same code with direct DB2 JDBC connection works fine.
> Any ideas?
>
> Thanks
> Dmitry Domnin
>
>
>