Index: C:/workspace/c4/java/net/sf/l2j/gameserver/SpawnTable.java =================================================================== --- C:/workspace/c4/java/net/sf/l2j/gameserver/SpawnTable.java (revision 1587) +++ C:/workspace/c4/java/net/sf/l2j/gameserver/SpawnTable.java (working copy) @@ -20,6 +20,7 @@ import java.sql.PreparedStatement; import java.sql.ResultSet; +import java.sql.SQLException; import java.util.Map; import java.util.logging.Logger; @@ -187,15 +188,20 @@ try { con = L2DatabaseFactory.getInstance().getConnection(); + con.setAutoCommit(false); PreparedStatement statement = con.prepareStatement("DELETE FROM spawnlist WHERE id=?"); statement.setInt(1, spawn.getId()); statement.execute(); statement.close(); + con.commit(); } - catch (Exception e) + catch (SQLException e) { // problem with deleting spawn - _log.warning("SpawnTable: Spawn " + spawn.getId() + " could not be removed from DB: " + e); + try { con.rollback(); } catch (SQLException e2) + { + _log.warning("SpawnTable: Spawn " + spawn.getId() + " could not be removed from DB: - SQL Rollback failed - " + e2); + } } finally {