--- dao/DaoAdresseVedligehold/src/main/java/dk/daoas/adressevedligehold/db/DatabaseCoverageUpdate.java	2016/04/25 08:02:15	3017
+++ dao/DaoAdresseVedligehold/src/main/java/dk/daoas/adressevedligehold/db/DatabaseCoverageUpdate.java	2016/04/25 08:44:37	3018
@@ -200,6 +200,8 @@
 			//con.setAutoCommit(false);
 			
 			try (PreparedStatement stmt = con.prepareStatement(sql)) {
+				int count = 0;
+				
 				for (Address addr : addresses) {
 					stmt.setString(1, addr.ruteMandag);
 					stmt.setString(2, addr.korelisteMandag);
@@ -219,14 +221,18 @@
 					stmt.setString(15, addr.distributor);
 					stmt.setInt(16, addr.dbkBane);
 					stmt.setInt(17, addr.id);
-
 					
-					stmt.execute();
-					if (stmt.getUpdateCount() != 1) {
-						logger.warning("Error executing update: " + addr);
-					}
 					
+					stmt.addBatch();
+					count++;
+					if (count >= 100) {
+						stmt.executeBatch();
+						count = 0;
+					}					
 				}
+				
+				stmt.executeBatch(); //update remainding queries
+				
 			}
 			
 			//con.commit();