db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From adkumar <a...@slb.com>
Subject Possible Connection Leak
Date Thu, 03 Jul 2003 16:52:24 GMT
Hi all,

    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


Mime
View raw message