[jira] [Comment Edited] (JCR-4579) jackrabbit-data: allow to disable statement pooling through system property

["Julian Reschke (Jira)" <ji...@apache.org>]

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

Julian Reschke edited comment on JCR-4579 at 2/11/21, 2:30 PM:
---------------------------------------------------------------

trunk: (2.21.2) [r1878846|http://svn.apache.org/r1878846]
2.20: (2.20.2) [r1879638|http://svn.apache.org/r1879638]
2.16: (2.16.7) [r1883981|http://svn.apache.org/r1883981]
2.14: [r1886429|http://svn.apache.org/r1886429]



was (Author: reschke):
trunk: (2.21.2) [r1878846|http://svn.apache.org/r1878846]
2.20: (2.20.2) [r1879638|http://svn.apache.org/r1879638]
2.16: [r1883981|http://svn.apache.org/r1883981]


> jackrabbit-data: allow to disable statement pooling through system property
> ---------------------------------------------------------------------------
>
>                 Key: JCR-4579
>                 URL: https://issues.apache.org/jira/browse/JCR-4579
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>          Components: jackrabbit-data
>            Reporter: Claus Köll
>            Assignee: Claus Köll
>            Priority: Major
>              Labels: candidate_jcr_2_12
>             Fix For: 2.14.9, 2.22, 2.16.7, 2.21.2, 2.20.2
>
>
> We are using a DriverDataSource and in really rare situations we see following exception
> {code:java}
> Closed Statement; nested exception is java.sql.SQLException: Closed Statement {code}
> The DriverDataSource uses the commons-dbcp library to create a BasicDataSource.
> The old commons-dbcp is also using a fairly old version of commons-pool.
> After researching a valid fix can be is to disable the pooling of PreparedStatements.
> As a quick fix i would define a SystemProperty to disable the pooling. We have a really high load and we see no performance impacts.
> As a future fix we can update to a actual dbcp2 version.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)