Tomcat Connection Pool Problems

["cornelius, chad" <chad.cornelius@xxxxxxxxxxxxxxxxxxxx>]

I am running into some problems on our production box running tomcat under
jvm 1.2  After several successful connections, I keep receiving the
following error:

com.ibm.db2.jdbc.app.DB2DBException: SQL system error.


       java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:94)


 
java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;I)V+1
(SQLException.java:43)                                

 
com/ibm/db2/jdbc/app/DB2SQLException2.<init>(Ljava/lang/String;Ljava/lang/St
ring;I[B)V+1 (DB2SQLException2.java:40)          

 
com/ibm/db2/jdbc/app/DB2DBException.<init>(Ljava/lang/String;Ljava/lang/Stri
ng;I[B)V+1 (DB2DBException.java:47)              

       com/ibm/db2/jdbc/app/DB2PreparedStatementRuntimeImpl.execute(II)I+40
(DB2PreparedStatementRuntimeImpl.java:408)              

       com/ibm/db2/jdbc/app/DB2PreparedStatement.execute()Z+28
(DB2PreparedStatement.java:1520)       

 
com/ibm/db2/jdbc/app/DB2PreparedStatement.executeQuery()Ljava/sql/ResultSet;
+12 (DB2PreparedStatement.java:261)              

 
org/apache/commons/dbcp/DelegatingPreparedStatement.executeQuery()Ljava/sql/
ResultSet;+9 (DelegatingPreparedStatement.java:2 

 
com/state/judicial/db/DBHandler.runQuery(Ljava/lang/String;)Ljava/util/Vecto
r;+0 (DBHandler.java:210)                        

 
org/apache/jsp/namestatus_jsp._jspService(Ljavax/servlet/http/HttpServletReq
uest;Ljavax/servlet/http/HttpServletResponse;)V+ 

 
org/apache/jasper/runtime/HttpJspBase.service(Ljavax/servlet/http/HttpServle
tRequest;Ljavax/servlet/http/HttpServletResponse 

 
javax/servlet/http/HttpServlet.service(Ljavax/servlet/ServletRequest;Ljavax/
servlet/ServletResponse;)V+26 (HttpServlet.java: 

 
org/apache/jasper/servlet/JspServletWrapper.service(Ljavax/servlet/http/Http
ServletRequest;Ljavax/servlet/http/HttpServletRe 

 
org/apache/jasper/servlet/JspServlet.serviceJspFile(Ljavax/servlet/http/Http
ServletRequest;Ljavax/servlet/http/HttpServletRe 

 
org/apache/jasper/servlet/JspServlet.service(Ljavax/servlet/http/HttpServlet
Request;Ljavax/servlet/http/HttpServletResponse; 

 
javax/servlet/http/HttpServlet.service(Ljavax/servlet/ServletRequest;Ljavax/
servlet/ServletResponse;)V+26 (HttpServlet.java: 

 
org/apache/catalina/core/ApplicationFilterChain.doFilter(Ljavax/servlet/Serv
letRequest;Ljavax/servlet/ServletResponse;)V+98  

 
org/apache/catalina/core/StandardWrapperValve.invoke(Lorg/apache/catalina/Re
quest;Lorg/apache/catalina/Response;Lorg/apache/ 

 
org/apache/catalina/core/StandardPipeline$StandardPipelineValveContext.invok
eNext(Lorg/apache/catalina/Request;Lorg/apache/c 

 
org/apache/catalina/core/StandardPipeline.invoke(Lorg/apache/catalina/Reques
t;Lorg/apache/catalina/Response;)V+8 (StandardPi 

 
org/apache/catalina/core/ContainerBase.invoke(Lorg/apache/catalina/Request;L
org/apache/catalina/Response;)V+4 (ContainerBase 

 
org/apache/catalina/core/StandardContextValve.invoke(Lorg/apache/catalina/Re
quest;Lorg/apache/catalina/Response;Lorg/apache/ 

 
org/apache/catalina/core/StandardPipeline$StandardPipelineValveContext.invok
eNext(Lorg/apache/catalina/Request;Lorg/apache/c 

 
org/apache/catalina/core/StandardPipeline.invoke(Lorg/apache/catalina/Reques
t;Lorg/apache/catalina/Response;)V+8 (StandardPi 

 
org/apache/catalina/core/StandardContext.invoke(Lorg/apache/catalina/Request
;Lorg/apache/catalina/Response;)V+78 (StandardCo 

.

.

.

 

After starting Tomcat on my pc, which is running jvm 1.3, I receive the
following message:

java.sql.SQLException: DBCP could not obtain an idle db connection, pool
exhausted

            at
org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool
.java:123)

            at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.ja
va:110)

            at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3
12)

            at com.state.judicial.db.Pool.getConnection(Pool.java:38)

            at com.state.judicial.db.DBHandler.runQuery(DBHandler.java:223)

            at
org.apache.jsp.namestatus_jsp._jspService(namestatus_jsp.java:98)

            at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

            at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3
20)

            at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:293)

            at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

            at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:286)

            at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)

            at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:254)

            at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:151)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)

            at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext
Valve.java:256)

            at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:210)

            at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:151)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)

            at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:190
)

            at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:151)

            at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:175
)

            at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:149)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)

            at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:156)

            at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:151)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:974)

            at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:207)

            at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:647)

            at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:489)

            at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:575)

            at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:649)

            at java.lang.Thread.run(Unknown Source)

 

Does anyone know what would cause this?  I have MaxActive sessions set to 0
for no limit.  I am pretty sure I am closing all connections correctly.