0 Replies Latest reply on Jul 3, 2002 2:44 AM by Sridhar J

    Connection Pool

    Sridhar J Newbie

      Hi All,

      I am using JBoss-2.4.4_Tomcat-3.2.3 application server and Database is
      Oracle 8.1.7 using the thin Drivers.

      An Entity Bean's Business method is invoked by a thread every second,
      where it opens a connection , checks the database table, does some functionality and closes the connection.

      There are totally 7 beans doing this sort of activity.
      At some duration all the components gets stopped (Hangs).
      The main reason is the DB Connection is not getting closed.

      The below mentioned are the parameters set in the configuration.

      2
      100
      true
      5000
      10000
      false
      false
      true
      5000
      true
      true
      1.0

      Just for the info the console output of Jboss.
      [INFO,Default] JBoss-2.4.4 Started in 0m:25s.907
      [INFO,EmbeddedCatalinaServiceSX] ConsoleCommandHandler: init
      [INFO,Default] process
      [INFO,OracleDB] Resource 'org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl@79b7b0' enlisted for 'org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@5cb03b'.
      [INFO,OracleDB] Resource 'org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl@79b7b0' enlisted for 'org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@5cb03b'.
      [INFO,OracleDB] No transaction right now.
      [INFO,OracleDB] No transaction right now.
      [INFO,OracleDB] org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl created new Connection (oracle.jdbc.driver.OracleConnection) with XAResource org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl.
      [INFO,OracleDB] No transaction right now.
      [INFO,OracleDB] org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl created new Connection (oracle.jdbc.driver.OracleConnection) with XAResource org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl.
      [INFO,OracleDB] No transaction right now.
      [INFO,OracleDB] org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl created new Connection (oracle.jdbc.driver.OracleConnection) with XAResource org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl.
      [INFO,OracleDB] No transaction right now.
      [INFO,OracleDB] org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl created new Connection (oracle.jdbc.driver.OracleConnection) with XAResource org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl.
      [INFO,OracleDB] Resource 'org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl@1c19e6' enlisted for 'org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@7c25e5'.
      [INFO,OracleDB] Resource 'org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl@1c19e6' enlisted for 'org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@7c25e5'.
      [INFO,Default] QMTDAO-->Closing the Connection
      [INFO,OracleDB] No transaction right now.
      [INFO,OracleDB] org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl created new Connection (oracle.jdbc.driver.OracleConnection) with XAResource org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl.
      [INFO,OracleDB] No transaction right now.
      [INFO,OracleDB] org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl created new Connection (oracle.jdbc.driver.OracleConnection) with XAResource org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl.
      [INFO,OracleDB] No transaction right now.
      [INFO,OracleDB] org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl created new Connection (oracle.jdbc.driver.OracleConnection) with XAResource org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl.
      [INFO,OracleDB] No transaction right now.
      [INFO,OracleDB] org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl created new Connection (oracle.jdbc.driver.OracleConnection) with XAResource org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl.
      [INFO,OracleDB] No transaction right now.


      After this the components stops and wakes up after some time when the connection is got,

      Pl let me know how to fix this i.e the Leak in the DBConnection and also closing the connection, sending it to the DB Pool and the Garbage collect the DB Connection.