PreparedStatement automatically close ResultSet (use try-with-resources or close this "ResultSet" in a "finally" clause)

[Ytnoos]

SonarLint 4.7.0.17141 on IntelliJ

When the PreparedStatement is closed, ResultSet is closed automatically so it doesn’t need to warn if the statement is inside a try with resources

[alban.auzeill]

Yes, the above issue is a false-positive. Java documentation contract for java.sql.Statement#close() is saying:

When a Statement object is closed, its current ResultSet object, if one exists, is also closed.

Ticket created: SONARJAVA-3430

Thanks for your feedback,

Alban