[Proxool-developer] Re: [Proxool-user] Debugging proxool Error

[Bill H. <bi...@lo...>]

Hi Kiran,

On Mon, 2003-12-15 at 22:29, Kiran T wrote:

> I tried to switch over my existing DB pool( called pool123 below) to Proxool 

What were you using before, out of interest?

> 0.8.2 in my web application running JRun3.0 . Now I seem to get the weird 
> error message during OnDeath() method call in the ConnectionListenerIF . It 
> reads

Have you implemented a ConnectionListenerIF? If so, can you post the
code?

> java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for 
> JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided 
> (abcdf5a) is not valid.

This looks very much like something trying to use a ResultSet that
either belongs to another Statement or has been closed.

> For all the connection open, I have close() method but I have not closed 
> Statement/PreparedStatement( assuming proxoll does). 

It does.

> There might be places 
> in the  code where Resultset might not have been closed. 

Technically, this is the delegate driver's responsibility (Your
SQLServer driver, that is). I don't think it can do any harm to close
ResultSets and Statements explicitly in your code.

Cheers,
Bill Horsman