[jira] Commented: (JCR-2767) Database connection leak with DBCP, MySQL, and Observers

["Christian Trimble (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/JCR-2767?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12917806#action_12917806 ] 

Christian Trimble commented on JCR-2767:
----------------------------------------

The connections that are being abandoned code from line 802 in org.apache.jackrabbit.core.journal.DatabaseJournal.  This class has an instance variable of type org.apache.jackrabbit.core.util.db.ConnectionHelper that it treats as a thread safe object.  However, the batch mode features of this class do not appear to be thread safe.  I have prepared a patch that makes the batch mode features of the ConnectionHelper class by moving its batchConnection into a thread local variable.

> Database connection leak with DBCP, MySQL, and Observers
> --------------------------------------------------------
>
>                 Key: JCR-2767
>                 URL: https://issues.apache.org/jira/browse/JCR-2767
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>          Components: jackrabbit-core
>    Affects Versions: 2.1.0
>         Environment: Jackrabbit with DBCP and MySQL
>            Reporter: Christian Trimble
>
> When using DBCP and MySQL with an observer that modifies the content repository, we are seeing abandoned connections in our connection pool.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.