I 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>
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3850690#3850690
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3850690
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
