Uploaded image for project: 'Jackrabbit Content Repository'
  1. Jackrabbit Content Repository
  2. JCR-4579

jackrabbit-data: allow to disable statement pooling through system property

    XMLWordPrintableJSON

    Details

      Description

      We are using a DriverDataSource and in really rare situations we see following exception

      Closed Statement; nested exception is java.sql.SQLException: Closed Statement 

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                c_koell Claus Köll
                Reporter:
                c_koell Claus Köll
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: