try { PreparedStatement statement2 = con.prepareStatement("SELECT mobId, itemId, min, max, sweep, chance FROM raid_droplist ORDER BY mobId,chance DESC"); ResultSet dropData = statement2.executeQuery(); L2DropData dropDat = null; L2NpcTemplate npcDat = null; while (dropData.next()) { int mobId = dropData.getInt("mobId"); npcDat = _npcs.get(mobId); dropDat = new L2DropData(); dropDat.setItemId(dropData.getInt("itemId")); dropDat.setMinDrop(dropData.getInt("min")); dropDat.setMaxDrop(dropData.getInt("max")); dropDat.setSweep(dropData.getInt("sweep") == 1); dropDat.setChance(dropData.getInt("chance")); npcDat.addDropData(dropDat); } dropData.close(); statement2.close(); } catch (Exception e) { _log.log(Level.SEVERE, "error reading raidboss drops ", e); }