I am using Tomcat 4.0.1/Win 2K/DB2 7.2 UDB.
Using OpenLoad to load test, after about 350 page hit I get the following
error:
DBCP borrowObject failed: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver]
SQL10
40N The maximum number of applications is already connected to the
database. S
QLSTATE=57030
org.apache.commons.dbcp.DbcpException: COM.ibm.db2.jdbc.DB2Exception:
[IBM][CLI
Driver] SQL1040N The maximum number of applications is already connected to
the
database. SQLSTATE=57030
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv
erConnectionFactory.java:85)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable
ConnectionFactory.java:184)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown S
ource)
at
org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObj
ectPool.java:117)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSo
urce.java:110)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:312)
at
com.circle.ims.table.ImsTableImpl.getPoolConnection(ImsTableImpl.java
:515)
at com.circle.ims.table.ImsTableImpl.insert(ImsTableImpl.java:265)
at com.circle.ims.table.WebActivity.logToDB(WebActivity.java:671)
at
com.circle.ims.logging.ImsObjectLogger$LogDaemon.run(ImsObjectLogger.
java:116)
Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1040N The
maximu
m number of applications is already connected to the database.
SQLSTATE=57030
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExce
ptionGenerator.java:174)
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExcep
tionGenerator.java:419)
at
COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java:432)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.java:335)
at COM.ibm.db2.jdbc.app.DB2Driver.connect(DB2Driver.java:353)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv
erConnectionFactory.java:83)
... 9 more
... and I keep on getting it.
Databas is configured to accept 100 connections.
The resource in server.xml is setup as following:
<Resource name="jdbc/myDS" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/myDS">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>10</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>username</name>
<value>db2admin</value>
</parameter>
<parameter>
<name>password</name>
<value>garfield</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>COM.ibm.db2.jdbc.app.DB2Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:db2:myDb</value>
</parameter>
</ResourceParams>
as you can see it is configured to keep only 20 active connections.
Any help would be appreciated.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
