--- dao/FuldDaekningWorker/src/main/java/dk/daoas/fulddaekning/Database.java 2016/01/19 11:16:55 2828 +++ dao/FuldDaekningWorker/src/main/java/dk/daoas/fulddaekning/Database.java 2016/01/19 11:19:21 2829 @@ -101,7 +101,7 @@ logger.info("Henter alle IKKE-daekkede adresser"); - String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,rute,p.distributor as ho " + + String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,ruteMa,p.distributor as ho " + "FROM fulddaekning.adressetabel a " + "LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + "WHERE ruteMa IS NULL " + //Ingen dækning @@ -160,7 +160,7 @@ public int hentAlleDaekkedeAdresser() throws SQLException { if ( alleAdresser == null ) { - String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,rute,p.distributor as ho " + + String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,ruteMa,p.distributor as ho " + "FROM fulddaekning.adressetabel a " + "LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + "WHERE ruteMa IS NOT NULL " +