I am testing Torques' old connection pool.
To test the connection I am running a query every minute. After every 45/46 minute, it looks like
a new connection is made and even after connection time out, it is not released.
Here is the test result.
SID SERIAL# USERNAME STATUS SCHEMANAME COMMAND TYPE LOGON_TIME OSUSER PROG
---------- ---------- ---------- -------- ---------- ---------- ---------- ----------------- -------
11 26 DP INACTIVE DP 0 USER 01-07-03 17:55:41 jdbcuser JDBC-1.0-Client
10 1637 DP INACTIVE DP 0 USER 01-07-03 18:40:49 jdbcuser JDBC-1.0-Client
19 2267 DP INACTIVE DP 0 USER 01-07-03 19:25:49 jdbcuser JDBC-1.0-Client
26 1582 DP INACTIVE DP 0 USER 01-07-03 20:11:49 jdbcuser JDBC-1.0-Client
8 1706 DP INACTIVE DP 0 USER 01-07-03 20:56:49 jdbcuser JDBC-1.0-Client
7 1497 DP INACTIVE DP 0 USER 01-07-03 21:42:49 jdbcuser JDBC-1.0-Client
25 625 DP INACTIVE DP 0 USER 01-07-03 22:27:49 jdbcuser JDBC-1.0-Client
27 341 DP INACTIVE DP 0 USER 01-07-03 23:12:50 jdbcuser JDBC-1.0-Client
24 1153 DP INACTIVE DP 0 USER 01-07-03 23:58:49 jdbcuser JDBC-1.0-Client
23 391 DP INACTIVE DP 0 USER 02-07-03 00:43:49 jdbcuser JDBC-1.0-Client
29 333 DP INACTIVE DP 0 USER 02-07-03 01:28:49 jdbcuser JDBC-1.0-Client
28 347 DP INACTIVE DP 0 USER 02-07-03 02:14:49 jdbcuser JDBC-1.0-Client
30 338 DP INACTIVE DP 0 USER 02-07-03 03:00:49 jdbcuser JDBC-1.0-Client
31 330 DP INACTIVE DP 0 USER 02-07-03 03:45:49 jdbcuser JDBC-1.0-Client
32 335 DP INACTIVE DP 0 USER 02-07-03 04:30:49 jdbcuser JDBC-1.0-Client
33 337 DP INACTIVE DP 0 USER 02-07-03 05:16:49 jdbcuser JDBC-1.0-Client
34 332 DP INACTIVE DP 0 USER 02-07-03 06:01:49 jdbcuser JDBC-1.0-Client
35 332 DP INACTIVE DP 0 USER 02-07-03 06:46:49 jdbcuser JDBC-1.0-Client
36 340 DP INACTIVE DP 0 USER 02-07-03 07:32:49 jdbcuser JDBC-1.0-Client
37 330 DP INACTIVE DP 0 USER 02-07-03 08:17:50 jdbcuser JDBC-1.0-Client
38 340 DP INACTIVE DP 0 USER 02-07-03 09:03:49 jdbcuser JDBC-1.0-Client
40 523 DP INACTIVE DP 0 USER 02-07-03 09:48:49 jdbcuser JDBC-1.0-Client
Torque properties file : (Partial)
###Using torque's old pool ##torque.dsfactory.test.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory ##torque.dsfactory.test.pool.defaultMaxConnections=10 ##torque.dsfactory.test.pool.maxExpiryTime=3600 ##torque.dsfactory.test.pool.connectionWaitTimeout=10 ##torque.dsfactory.test.connection.driver = oracle.jdbc.driver.OracleDriver ##torque.dsfactory.test.connection.url = jdbc:oracle:thin:@localhost:1521:dp ##torque.dsfactory.test.connection.user = dp ##torque.dsfactory.test.connection.password = dp ##torque.dsfactory.test.connection.logInterval=1 ##torque.database.adapter.DBOracle=oracle.jdbc.driver.OracleDriver
Any one got an idea what is wrong with Torque connection pooling ? Thanks in advance.
Anil
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
