Anonymous

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
             {