[SLING-5879] StatementCache interceptor configured by default causes ResultSets to remain open

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: DataSource Provider 1.0.2
• Component/s: Commons
• Assignee: Chetan Mehrotra
• Reporter: Andrei Dulceanu
• Created: 21/Jul/16 08:21
• Updated: 24/Oct/16 10:48
• Resolved: 13/Oct/16 08:54

Description

Configuring StatementCache interceptor in org.apache.sling.datasource, prevents the RDBDocumentStore to correctly start up due to a bug in the StatementCache interceptor (see https://bz.apache.org/bugzilla/show_bug.cgi?id=59850).

Recommended solution is to update the tomcat pool to a fixed version (7.0.71) once it's out. Until that is the case we can

• recommend not to turn on the StatementCache, or
• use a recent Oak version which works around the bug (OAK-4559).

Issue Links

• relates to: OAK-4559 RDB*Store: failures with Tomcat JDBC pool's StatementCache interceptor
• relates to: OAK-4583 RDB*Store: update Tomcat JDBC pool dependency
• links to: ASF Bugzilla – Bug 59850