JBoss Connection Poling
raman2072 Oct 7, 2004 7:30 PMI have implemented a connection pool in JBoss and everything seemed to be fine in developemnt environment. The moment it went to QA I have a problem where server starts fine, the conenction pool is getting created, it serves some requests and bang it goes down. Since I am using a connection pool I am not exclusively closing them, just returning back to pool. So I am much mused by this exception trace which I get here.
I have also specified by oracleDS.xml file props below this trace.
=============================================
Exception Trace
=============================================
2004-10-07 13:54:25,302 INFO
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
Exception destroying ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested
throwable: (java.sql.SQLException: Io exception: Connection timed out)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:445)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:229)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:374)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.removeTimedOut(InternalManagedConnectionPool.java:288)
at
org.jboss.resource.connectionmanager.IdleRemover$1.run(IdleRemover.java:70)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Io exception: Connection timed out
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at
oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1478)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:225)
============================================
Oracle Ds.xml
============================================
<?xml version="1.0" encoding="UTF-8"?>
<local-tx-datasource>
<jndi-name>jdbc.CQ30</jndi-name>
<connection-url>jdbc:oracle:thin:@db1:1521:CQ30</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>sat_app</user-name>
pied1
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<min-pool-size>20</min-pool-size>
<max-pool-size>30</max-pool-size>
</local-tx-datasource>
<local-tx-datasource>
<jndi-name>jdbc.MQ30</jndi-name>
<connection-url>jdbc:oracle:thin:@db2:1521:MQ30</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>slr_server</user-name>
pied1
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<min-pool-size>20</min-pool-size>
<max-pool-size>30</max-pool-size>
</local-tx-datasource>