Re: java.sql.SQLException: Result set already closed

Jeroen Kassels wrote:

> Hi Joe,
> 
> I am trying todo exactly what is described here resulting in the same
exception
> ('java.sql.SQLException: Result set already closed' error.).
> 
> Running on wls 922 and trying to invoke a JDBCControl wrapped in a Custom
control.
> The JDBCControl invokes a procedure on Oracle 10 which returns a refcursor.
I do
> understand that we can solve this by using plain old JDBC without the
controls
> but that is just what we want to get away from.
> 
> Any input appreciated.
> 
> -cheers
> -jeroen

You can't expect JDBC objects to survive outside the scope of the JDBC-hiding
scope
of controls. By JDBC spec, any closing of a connection or closing or
re-executing