[ https://issues.apache.org/jira/browse/PHOENIX-1372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14947072#comment-14947072 ]
Ted Yu commented on PHOENIX-1372: --------------------------------- The patch was attached almost a year ago - it needs some polishing. I didn't run maven verify. > Fix resource leaks in various classes > ------------------------------------- > > Key: PHOENIX-1372 > URL: https://issues.apache.org/jira/browse/PHOENIX-1372 > Project: Phoenix > Issue Type: Bug > Reporter: Ted Yu > Assignee: Ted Yu > Labels: resources > Attachments: 1372-v1.txt > > > Statement / PreparedStatement should be closed after query completes. > Below is an example of resource leak from > MetaDataUtil#deleteViewIndexSequences(): > {code} > public static void deleteViewIndexSequences(PhoenixConnection > connection, PName name) throws SQLException { > SequenceKey key = getViewIndexSequenceKey(null, name); > connection.createStatement().executeUpdate("DELETE FROM " + > PhoenixDatabaseMetaData.SEQUENCE_TABLE_NAME + > {code} > The Statement created by connection.createStatement() should be closed upon > return. -- This message was sent by Atlassian JIRA (v6.3.4#6332)