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

Connection Pool

jsjsjothi Jul 3, 2002 2:44 AM

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.