0 Replies Latest reply on Oct 7, 2004 7:30 PM by raman2072

    JBoss Connection Poling

    raman2072 Newbie

      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>