Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql,v
diff -u -r1.6 -r1.7
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql	6 Nov 2008 23:31:42 -0000	1.6
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql	6 Nov 2008 23:43:39 -0000	1.7
@@ -1,4 +1,10 @@
 -- SQL statements to update from LAMS 2.1/2.1.1
+
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
 -- LDEV1909 - Competence Editor Update Scripts ---------------------------------
 CREATE TABLE lams_competence (
        competence_id BIGINT NOT NULL UNIQUE auto_increment
@@ -49,4 +55,10 @@
 VALUES (10, 14, 'Condition Gate', 'Gate: Opens if conditions are met', 
 	'learning/gate.do?method=knockGate', 'learning/gate.do?method=knockGate', null, null, 
 	'monitoring/gateExportPortfolio?mode=teacher', 'monitoring/gate.do?method=viewGate', 
-	'monitoring/gate.do?method=viewGate', now()	);
\ No newline at end of file
+	'monitoring/gate.do?method=viewGate', now()	);
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 0
\ No newline at end of file