public void addAllyMember(L2Clan newClan) { _members.put(newClan.getName(), newClan); // store in db storeNewMembersInDatabase(newClan); } private void storeNewMembersInDatabase(L2Clan member) { java.sql.Connection con = null; L2ClanMember[] members = member.getMembers(); for (int i = 0; i < members.length; i++) { try { con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("UPDATE characters SET allyid=? WHERE obj_Id=?"); statement.setInt(1, getAllianceId()); statement.setInt(2, members[i].getObjectId()); statement.execute(); statement.close(); if (Config.DEBUG) _log.fine("New clan member saved in db: "+members[i].getObjectId()); } catch (Exception e) { _log.warning("error while saving new clan member to db "+e); } finally { try { con.close(); } catch (Exception e) {} } } }}