--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2014/09/20 11:28:20 2225 +++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2014/09/29 18:15:48 2230 @@ -53,6 +53,8 @@ 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; + + logger.info("Executing: " + sql); conn.createStatement().executeUpdate(sql); } @@ -156,7 +158,7 @@ String sql = "SELECT id,postnr,adresse,gadeid,husnr,husnrbogstav,latitude,longitude,rute " + "FROM fulddaekning.adressetabel " + "WHERE rute IS NOT NULL " + - "AND latitude IS NOT NULL" + + "AND latitude IS NOT NULL " + "AND longitude IS NOT NULL " + "AND distributor = ? ";