| guest |
Fri Aug 03 21:02:21 BST 2007 |
| |
I start up a pool in Tomcat with a base of 10 and an overfow of 20. After 2 minutes (the set timeout), the pools start dumping as is the expected behavior. Let's say all the pools dump down to zero connections. When a request is made for a connection, the process either hangs or takes a long time. Could I have a misconfiguration in the properties file to cause this behavior?
poolName=myFirstPool
base=10
overflow=20
idleTime=120000
messageLogging=true
sizeLogging=true
driverClass=com.therightdriver.com
driverURL=jdbc:dbconnection/server.com
user=username
password=password
killActiveConnectionsOverAge=120000
cycleConnections=1000
queueConnectionRequests=true
runPooledMode=true
connectionAutoCommit=false
checkSQL=select count(*) from nations
encryptionKeyFile=PrimrosePool.keys
#connectionTransactionIsolation=TRANSACTION_READ_COMMITTED
log=PrimrosePools_${yyyy-MM-dd}.log |
| |
| sedj |
Mon Aug 06 12:26:44 BST 2007 |
| |
Have you tried not running some checkSQL ?
What database are you using ? |
| guest |
Mon Aug 06 13:18:48 BST 2007 |
| |
| Database is Attunity - http://www.attunity.com. I will try removing the checkSQL and see if the results change. Why should removing the checkSQL matter? |
| sedj |
Mon Aug 06 14:48:45 BST 2007 |
| |
| Because if you define checkSQL - then that SQL statement is run each time ... and if its running on a fresh connection, the db may not be caching the statement - which may be the problem. |
| guest |
Mon Aug 06 14:59:07 BST 2007 |
| |
| Ok. Let's assume it is running the checkSQL. This might account for a slowness. Let's even say it gives it a 5 second slowdown (it takes five seconds to execute the query for whatever reason). It still does not explain it issue that I am having. In the above scenario once the pool is completely dumped (due to timeouts), then when a request is made from the pool, the request sits and churns as if it is waiting for a connection. However, there are plenty of "server-side" connections available and available to be created. |
|
