[JCR-4579] jackrabbit-data: allow to disable statement pooling through system property

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.14.9, 2.22, 2.16.7, 2.21.2, 2.20.2
• Component/s: jackrabbit-data
• Assignee: Claus Köll
• Reporter: Claus Köll
• Created: 03/Jun/20 09:37
• Updated: 03/Jun/24 11:10
• Resolved: 15/Jun/20 05:57

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.

Issue Links

• relates to: JCR-4521 When will Jackrabbit support dbcp 2.0