I know the situation that the reliable check is to validate connection by
executing simple SQL query; Actually we used the simple SQL - select 1 from
dual, but the total soft parse is 48%, and 700 queries per second happened
from oracle awr report, which certainly would bring impact to db
performan
I think the only reliable way to check whether connection is valid is to
execute something using the connection (so it requires roundtrip to db).
However
a) this execution happens only once for your transaction (which may include
numbers of CRUD operations etc)
b) Validation query is chosen to be s
Hi all,
When I was using the "validationQuery" and "testOnBorrow" properties to
ensure connection works fine, did it mean two round-trip happened?
Validation query and my SQL query? thus, how to reduce the db round-trip
while the query became huge?
I knew iBatis to mysql would not ensure connecti
