Hi All, I am using the tomcat-jdpc-pool from within my spring application. I am noticing a discrepancy between the numActive/numIdle values that the pool reports versus the actual number of established connections to the database.
For example, the pool reports 0 active and 4 idle connections while my netstat shows 5 connections established. Is this the correct behaviour? Below is a trace from within my app where host super.odbc=172.22.12.84. As you can see from the time stamps, the numbers do not add up in terms of idle connections. My config is shown at the bottom: I am using the jars: tomcat-juli-7.0.39.jar & tomcat-jdbc-7.0.39.jar 2013-04-16 16:04:38,695 DEBUG super.odbc: active:0 idle: 4 max:50 pamsdev: active:0 idle: 20 max:50 sa: active:0 idle: 17 max:50 2013-04-16 16:04:43,696 DEBUG super.odbc: active:0 idle: 4 max:50 pamsdev: active:0 idle: 20 max:50 sa: active:0 idle: 17 max:50 2013-04-16 16:04:48,697 DEBUG super.odbc: active:0 idle: 4 max:50 pamsdev: active:0 idle: 20 max:50 sa: active:0 idle: 17 max:50 2013-04-16 16:04:53,698 DEBUG super.odbc: active:0 idle: 4 max:50 pamsdev: active:0 idle: 20 max:50 sa: active:0 idle: 17 max:50 2013-04-16 16:04:58,699 DEBUG super.odbc: active:0 idle: 5 max:50 pamsdev: active:0 idle: 20 max:50 sa: active:0 idle: 17 max:50 2013-04-16 16:05:03,699 DEBUG super.odbc: active:0 idle: 5 max:50 pamsdev: active:0 idle: 20 max:50 sa: active:0 idle: 17 max:50 NETSTAT trace: Apr 16 16:04:38 172.22.12.84 = 5 172.22.12.85 = 0 10.115.250.9 = 0 172.22.12.42 = 28 10.115.250.8 = 0 Apr 16 16:04:43 172.22.12.84 = 5 172.22.12.85 = 0 10.115.250.9 = 0 172.22.12.42 = 28 10.115.250.8 = 0 Apr 16 16:04:48 172.22.12.84 = 5 172.22.12.85 = 0 10.115.250.9 = 0 172.22.12.42 = 23 10.115.250.8 = 0 Apr 16 16:04:53 172.22.12.84 = 5 172.22.12.85 = 0 10.115.250.9 = 0 172.22.12.42 = 23 10.115.250.8 = 0 Apr 16 16:04:58 172.22.12.84 = 5 172.22.12.85 = 0 10.115.250.9 = 0 172.22.12.42 = 24 10.115.250.8 = 0 Apr 16 16:05:03 172.22.12.84 = 5 172.22.12.85 = 0 10.115.250.9 = 0 172.22.12.42 = 24 10.115.250.8 = 0 ppfe.database.url=jdbc\:t4sqlmx\://ppfe-za-qa-db\:18650 ppfe.database.driverClassName=com.tandem.t4jdbc.SQLMXDriver ppfe.database.username=xxx ppfe.database.password=xxx ppfe.database.catalog=xxx ppfe.database.schema=xx ppfe.database.initialPoolSize=10 ppfe.database.maxPoolSize=50 ppfe.database.defaultTransactionIsolation=1 ppfe.database.maxStatements=7000 ppfe.database.maxIdle=5 ppfe.database.minIdle=5 ppfe.database.maxWait=10000 ppfe.database.testConnectionOnCheckout=false ppfe.database.testConnectionOnCheckin=false ppfe.database.testWhileIdle=true ppfe.database.timeBetweenEvictionRunsMillis=60000 ppfe.database.numTestsPerEvictionRun=3 ppfe.database.minEvictableIdleTimeMillis=60000 ppfe.database.logAbandoned=true ppfe.database.removeAbandoned=true ppfe.database.poolPreparedStatements=true ppfe.database.maxConnectionAge=300000 #Defines the query that will be executed for all connection tests ppfe.database.preferredTestQuery=select count(*) from NODUS BROWSE ACCESS ppfe.database.debugUnreturnedConnectionStackTraces=true ppfe.database.unreturnedConnectionTimeout=60 ppfe.database.checkoutTimeout=3