Hammurapi 3 [Inspector]

ER-207 SQL Resource Management - Create Statement Without Close Rule: You have to close each created SQL Statement on method level. Use the finally block, but check for null value. If you use a operation in the finally block for closing your SQL resource, please define the operation name in the inspector.xml. Hammurapi will search for this method call and check the parameter list. This rule is only applicable in a connection-pooled environment.

Severity	1
Enabled	yes
Waivable
Configuration	Configured releaseResource method names: releaseConnection releaseResources
Violation	public void select(){ try { Statement stmt = dbConnection.createStatement(); stmt.execute("SELECT * FROM DUAL" ); } catch (Exception ex){ ex.printStackTrace(); }
Fix	public void select(){ try { Statement stmt = dbConnection.createStatement(); stmt.execute("SELECT * FROM DUAL" ); } catch (Exception ex){ ex.printStackTrace(); } finally { stmt.close(); }