Hi everyone,
I wrote a simple test program to check if the closed connections are returned to POOL. I am using websphere 5.1.1.3. In one of the classes I am opening 20 connections, and immediately closing 19 connections and doing some processing with one connection to read data from DB2 and wait for 10 mins (using wait(600000)). I set pool param to be: 'Unused timeout=180 secs', max connections=25, min connections=1, Aged time out=0....Note that I am using Data Source to get the connections. Everything is working fine except that the connections are not released until wait time is finished (i.e. 10 mins or 600000 milli secs). Alos note that I set the reaptime as 18 secs (it is too low but for testing I used this). I am using Tivoli performance viewer to monitor the connection i the pool and DB2. I use this class (servlet) and start from a browser.
Help me if there is anything I am doing wrong. Thanks...
I wrote a simple test program to check if the closed connections are returned to POOL. I am using websphere 5.1.1.3. In one of the classes I am opening 20 connections, and immediately closing 19 connections and doing some processing with one connection to read data from DB2 and wait for 10 mins (using wait(600000)). I set pool param to be: 'Unused timeout=180 secs', max connections=25, min connections=1, Aged time out=0....Note that I am using Data Source to get the connections. Everything is working fine except that the connections are not released until wait time is finished (i.e. 10 mins or 600000 milli secs). Alos note that I set the reaptime as 18 secs (it is too low but for testing I used this). I am using Tivoli performance viewer to monitor the connection i the pool and DB2. I use this class (servlet) and start from a browser.
Help me if there is anything I am doing wrong. Thanks...