RE: testOnBorrow = true

2018-04-17 Thread Kota, Sriraghavi Latha
= true validationInterval = 30 (5 mins) Option2: testOnBorrow = true validationInterval = 30 (5 mins) validationQuery = "SELECT 1 from SYSIBM.SYSDUMMY1" Along with the above option1 or option2 can we add the below parameters also? testWhileIdle = true removeAbando

RE: testOnBorrow = true

2018-04-16 Thread Kota, Sriraghavi Latha
= true validationInterval = 30 (5 mins) Option2: testOnBorrow = true validationInterval = 30 (5 mins) validationQuery = "SELECT 1 from SYSIBM.SYSDUMMY1" Along with the above option1 or option2 can we add the below parameters also? testWhileIdle = true removeAbando

Re: testOnBorrow = true

2018-04-15 Thread Christopher Schultz
JDBCDriver: DB2JCC 4.22.9 > > Does testonBorrow = true issue a select statement to the database > to validate the connection or is that a OPING which is a > lightweight RPC? This depends upon a couple of things. Tomcat 8.5 uses DBCP2 as the default connection pool, but you can also use

testOnBorrow = true

2018-04-14 Thread Kota, Sriraghavi Latha
Hello, We are on Tomcat 8.5.23. We are trying to add fix to recover application after database restart. Here are our versions: Tomcat 8.5.23 DB2 version: 11.1 JDBCDriver: DB2JCC 4.22.9 Does testonBorrow = true issue a select statement to the database to validate the connection or is that a