Mantis - Resin
Viewing Issue Advanced Details
1314 minor always 08-23-06 11:48 09-05-06 13:46
ferg  
ferg  
normal  
closed  
fixed  
none    
none 3.1.0  
0001314: clear DBPool
(rep by Sergiy Proskuryakov)

Is there anyway to reset or purge connection pool in Resin w/o restarting?
We?ve had an issue with oracle giving us error - ORA-01000: maximum open cursors exceeded.
After awhile Resin has thrown this error - javax.resource.ResourceException: Connection pool is full. Can't allocate connection.
 
We have critical production information which got stuck.
The Resin instance is not taking any traffic right now.
We have a way to awake one of our threads which will try to post data into the database.
 
Our system:
Starting Resin on Sat, 19 Aug 2006 00:14:28 -0400 (EDT)
[00:14:30.016] Windows 2003 5.2 x86
[00:14:30.016] Java 1.5.0_06-b05, 32, mixed mode, Cp1252, en, Sun Microsystems Inc.
[00:14:30.016] resin.home = D:\resin-pro-3.0.20
[00:14:30.016] server.root = D:\resin-pro-3.0.20
[00:14:30.016]
[00:14:30.094] Loaded Socket JNI library.
[00:14:30.109] http listening to *:8080
[00:14:30.109] hmux listening to 127.0.0.1:6802

There are no notes attached to this issue.