--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2015/06/14 15:15:00 2589 +++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2015/06/14 15:24:44 2590 @@ -69,10 +69,10 @@ conn.createStatement().executeUpdate(sql); logger.info("Rename tables"); - sql = "RENAME TABLE fulddaekning.afstand_anden_rute" + ext + " TO fulddaekning.afstand_anden_rute_old" + ext + ", fulddaekning.afstand_anden_rute_ny TO fulddaekning.afstand_anden_rute" + ext; + String sql2 = "RENAME TABLE fulddaekning.afstand_anden_rute" + ext + " TO fulddaekning.afstand_anden_rute_old" + ext + ", fulddaekning.afstand_anden_rute_ny TO fulddaekning.afstand_anden_rute" + ext; - logger.info("Executing: " + sql); - conn.createStatement().executeUpdate(sql); + logger.info("Executing: " + sql2); + conn.createStatement().executeUpdate(sql2); } public BoundingBox getBoundingbox(short postnr) {