It seems that when enabling the StatementCache interceptor, closeing the (proxy) statement does not cause open ResultSets to be closed. This seems to be incorrect according to the Javadoc for Statement: "A ResultSet object is automatically closed when the Statement object that generated it is closed, re-executed, or used to retrieve the next result from a sequence of multiple results." -- <http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSet.html>
See related bug <https://issues.apache.org/jira/browse/OAK-4559>, including instructions how to reproduce.
Thanks for the report. Fixed at r1753454, r1753455, r1753456. and r1753457. - 9.0.x for 9.0.0.M10 onwards - 8.5.x for 8.5.5 onwards - 8.0.x for 8.0.37 onwards - 7.0.x for 7.0.71 onwards
Thanks for the fix. I tried with trunk, and the problem indeed seems to be gone.