[CAMEL-8715] camel-sql - Should close ResultSet

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.15.1
• Fix Version/s: 2.14.3, 2.15.3, 2.16.0
• Component/s: camel-sql
• Estimated Complexity: Unknown
• Assignee: Claus Ibsen
• Reporter: Claus Ibsen
• Created: 29/Apr/15 05:40
• Updated: 29/Apr/15 11:13
• Resolved: 29/Apr/15 11:13

Description

See SO
http://stackoverflow.com/questions/29933629/apache-camel-sql-component-is-not-closing-resultset

The Spring javadocs says

• <p><b>NOTE:</b> Any ResultSets opened should be closed in finally blocks
• within the callback implementation. Spring will close the Statement
• object after the callback returned, but this does not necessarily imply
• that the ResultSet resources will be closed: the Statement objects might
• get pooled by the connection pool, with {@code close}

  calls only

• returning the object to the pool but not physically closing the resources.