Untitled

private int transformSelectInfo()
    {
        java.sql.Connection con = null;
        try
        {
            con = L2DatabaseFactory.getInstance().getConnection();
            PreparedStatement statement;

            statement = con.prepareStatement(SELECT_CHAR_TRANSFORM);
            statement.setInt(1, getObjectId());
            ResultSet rset = statement.executeQuery();
            rset.next();
            _transformationId = rset.getInt("transform_id");
            statement.close();
            return _transformationId;
        }
        catch (Exception e)
        {
            _log.severe(e.toString());
        }
        finally
        {
            try { con.close(); } catch (Exception e) {}
        }
        return _transformationId = 0;
    }