You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by Marc Logemann <de...@logemann.info> on 2002/07/16 12:04:27 UTC

DBCP: returning non-existant connections

Hi,

i am getting back connections that physically doesnt exists from
DBCP. This happens from time to time and i cant see a pattern. Sometimes
(when doing a reload on a servlet) its happens every second time.

in this trace you see 3 connections that were established without problems. After
the "ok", i ve done another request, but this time, the @18c connection
is physically not there. On my database machine, i see only one connection
(i cant see which object of the three holds the one physical connection), but
obviously its not the @18c

Despite the connections on my DB machine are varying quite often. I allways thought
that i have something like a constant number of open connections to my database which will
be reused.

Any thoughts are welcome, also any thoughts on how to trace this better...

----
Starting service Tomcat-Standalone
Apache Tomcat/4.0.4
Using Connection: org.apache.commons.dbcp.PoolableConnection@e7c5cb
Using Connection: org.apache.commons.dbcp.PoolableConnection@18c74
Using Connection: org.apache.commons.dbcp.PoolableConnection@21e554
ok
Using Connection: org.apache.commons.dbcp.PoolableConnection@18c74
java.sql.SQLException: The connection does not exist.
        at com.ibm.as400.access.JDError.throwSQLException(Unknown Source)
        at com.ibm.as400.access.JDError.throwSQLException(Unknown Source)
        at com.ibm.as400.access.AS400JDBCConnection.checkOpen(Unknown Source)
        at com.ibm.as400.access.AS400JDBCConnection.createStatement(Unknown Sour
ce)
        at com.ibm.as400.access.AS400JDBCConnection.createStatement(Unknown Sour
ce)
        at org.apache.commons.dbcp.DelegatingConnection.createStatement(Delegati
ngConnection.java:172)
        at de.bahr.businessobjects.GateKeeper.authentify(GateKeeper.java:62)
[..]
---
greetings from
Marc Logemann
Homebase @ www.logemann.info


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>