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; }