DBCP Returns a closed connection even though testOnBorrow is set to true
------------------------------------------------------------------------
Key: DBCP-274
URL: https://issues.apache.org/jira/browse/DBCP-274
Project: Commons Dbcp
Issue Type: Bug
Affects Versions: 1.2.2
Reporter: Khawaja Shams
Hello,
I am using a BasicDataSource to acquire connections. The particular service
that is facing the issue basically goes through periods of high activity
followed by many hours of idle time. After long idle times, DBCP starts
returning closed connections. I tried setting the testOnBorrow flag BEFORE any
connections were acquired, but it has not helped the situation. One caveat is
that I am not setting the validationQuery string. This is only because as far
as I could tell, if the validationQuery is null, the pool will simply check if
the connection is open. Please let me know if I can provide any more
information.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.