commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khawaja Shams (JIRA)" <j...@apache.org>
Subject [jira] Closed: (DBCP-274) DBCP Returns a closed connection even though testOnBorrow is set to true
Date Fri, 19 Sep 2008 03:54:44 GMT

     [ https://issues.apache.org/jira/browse/DBCP-274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Khawaja Shams closed DBCP-274.
------------------------------

    Resolution: Invalid

I am sorry; it turns out that I did need to set the validationQuery string as the createDataSource
method sets the test properties to false.  

> 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.


Mime
View raw message