sonarqube-8.4.0.35506 sonar-scanner-4.4.0.2170-windows NetBeans 8.2, jdk1.8.0_241 Hi, according to Sonnarqube, why the next code is a bug? PreparedStatement pst = null; ResulSet rs = null; try { pst= myConnection.prepareStatement (A_SELECT_QUERY); rs = pst.executeQuery (); while…

Hi, Welcome to the community! According to the javadoc the ResultSet.close method throws SQLException. If your rs.close() call does that, then pst.close is never reached. So either you do this laborious exercise: finally { try { if (rs != null){ rs.close(); } } finally { i…

Use try-with-resources or close this "PreparedStatement" in a "finally" clause

SonarQube Server / Community Build

Gabriel_Moreno (Gabriel Moreno) July 22, 2020, 3:26pm 3

Hi Ann
Thank you for your help! I could resolve the error follow your indicationes. I use Java 1.8, so I can’t use “try-with-resources”. Its ok for me use try/catch/finally.

Best regards.
Gabriel

Topic		Replies	Views
S2095 - PreparedStatement closure in finally ignored when not first line SonarQube Server / Community Build java , bug-no-category	2	2469	November 1, 2021
Misreport on rule "Resources should be closed (java:S2095)" Report False-positive / False-negative... java	2	945	May 4, 2021
PreparedStatement automatically close ResultSet (use try-with-resources or close this "ResultSet" in a "finally" clause) Report False-positive / False-negative... java	2	4848	May 25, 2020
SonarQube giving false positive for PreparedStatement / ResultSet etc Report False-positive / False-negative... java	9	1007	December 3, 2020
Close "PreparedStatement" in a "finally" clause with Spring JdbcTemplate Report False-positive / False-negative... java	3	4207	September 13, 2019

Use try-with-resources or close this "PreparedStatement" in a "finally" clause

Related topics