code: protected void deleteLockProperties() throws SQLException, RepositoryException
     {
        addChange(TYPE_DELETE_LOCK);
        PreparedStatement findItemsStatement = null;
        PreparedStatement removeValueStatement = null;
        PreparedStatement removeItemStatement = null;
        ResultSet resultSet = null;
  
        try
        {
           findItemsStatement = dbConnection.prepareStatement("SELECT ID FROM " + JCR_ITEM + " WHERE I_CLASS = 2 AND CONTAINER_NAME = ? AND "
                   + " ( NAME = '[http://www.jcp.org/jcr/1.0]lockIsDeep' OR"
                   + " NAME = '[http://www.jcp.org/jcr/1.0]lockOwner' )");
  
           removeValueStatement = dbConnection.prepareStatement("DELETE FROM " + JCR_VALUE + " WHERE PROPERTY_ID = ?");
           removeItemStatement = dbConnection.prepareStatement("DELETE FROM " + JCR_ITEM + " WHERE ID = ? ");
  
           findItemsStatement.setString(1, this.containerConfig.containerName);
           resultSet = findItemsStatement.executeQuery();
           while (resultSet.next())
           {
              String id  = resultSet.getString(COLUMN_ID);
  
              removeValueStatement.clearParameters();
              removeValueStatement.setString(1, id);
              removeValueStatement.executeUpdate();
  
              removeItemStatement.clearParameters();
              removeItemStatement.setString(1, id);
              removeItemStatement.executeUpdate();
           }
        }
        finally
        {
           if (removeValueStatement != null)
           {
              try
              {
                 removeValueStatement.close();
              }
              catch (SQLException e)
              {
                 LOG.error("Can't close statement", e);
              }
           }
  
           if (removeItemStatement != null)
           {
              try
              {
                 removeItemStatement.close();
              }
              catch (SQLException e)
              {
                 LOG.error("Can't close statement", e);
              }
           }
        }
     }
docs: {@inheritDoc}