|
midrange.com
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
