Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Websphere Database connection closed

843854May 28 2004 — edited Jun 11 2004

We are using websphere server for our J2EE application. We are facing a pecular problem. We test the application in unit mode with few users working it works fine. But when start stress testing the application we hava data base connection error. Like failed to get database connection.
Any help will be appreciated.

Parvesh Jain
One of them i am writing here

[5/28/04 10:31:58:763 EDT] 31d8c55e ConnectionPoo X CONM6009E: Failed to get connection to the database from datasource (cpsdatasource).
[5/28/04 10:31:58:788 EDT] 31d8c55e StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -99,999 and SQLState 08003, to a StaleConnectionException: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java(Compiled Code))
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2Connection.getTransactionIsolation(DB2Connection.java:1156)
at com.ibm.ejs.cm.pool.ConnectO.initialize(ConnectO.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectO.<init>(ConnectO.java(Compiled Code))
at com.ibm.ejs.cm.pool.JTAConnectionFactory.createConnection(JTAConnectionFactory.java(Inlined Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java(Inlined Compiled Code))
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java(Compiled Code))
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java(Compiled Code))

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2004

Added on May 28 2004

#java-database-connectivity-jdbc

9 comments

1,044 views