RLK.SQLOBJRLK (Resource Leak) issues are reported when resources are allocated but not properly disposed after use. Failing to properly dispose a resource can lead to such problems as:
An RLK.SQLOBJ warning indicates that a Java SQL API object (other than an SQL connection) is not closed on exit. Vulnerability and riskResources such as streams, connections and graphic objects must be explicitly closed. The close operation can unblock transactions or flush file changes in the file system. While a resource will eventually be closed by the garbage collector, resource exhaustion can occur before garbage collection starts. Depending on the nature of the resource, various exceptions will be thrown on a failed attempt to allocate another resource, for example: java.io.FileNotFoundException: Too many open files or too many database connections. Mitigation and preventionExplicitly close all resources that have the close method, even those that you think are not doing anything significant. Future code changes will then be safe from such errors. Example 117 public void cleanUp(Connection con, int... ids) throws SQLException { 18 PreparedStatement statement = con.prepareStatement("delete from entity where id=?"); // Resource allocated 19 for (int id : ids) { 20 statement.setInt(1, id); 21 statement.executeUpdate(); 22 } 23 } RLK.SQLOBJ is reported for the snippet on line 18: Sql object 'statement' is not closed on exit. Related checkersExtensionThis checker can be extended through the Klocwork knowledge base. See Tuning Java analysis for more information. |