[Proxool-developer] Debugging proxool Error

[Kiran T <mah...@ho...>]

Hi Bill,

I tried to switch over my existing DB pool( called pool123 below) to Proxool 
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

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

"[ERROR] pool123 - -#0004 encountered errors during closure:  
<java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for 
JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided 
(abcdf5a) is not valid.>

After few instances of these errors I then get an error "Exception occurred 
during fill/append.[Microsoft][SQLServer 2000 Driver for 
JDBC][SQLServer]Could not allocate new page for database 'tempdb'. There are 
no more pages available in filegroup DEFAULT. Space can be created by 
dropping objects, adding additional files, or allowing file growth.
Increasing the cache could not solve this problem.

For all the connection open, I have close() method but I have not closed 
Statement/PreparedStatement( assuming proxoll does). There might be places 
in the  code where Resultset might not have been closed. Similarly, I have 
used selectMethod as cursor irrespective of Transaction or non trnasactional 
query.

Any insight is highly appreciated.

Thanks
Kiran

_________________________________________________________________
Don’t worry if your Inbox will max out while you are enjoying the holidays.  
Get MSN Extra Storage!  http://join.msn.com/?PAGE=features/es