--- dao/FuldDaekningWorker/src/main/java/dk/daoas/fulddaekning/Database.java 2015/11/05 08:06:00 2769 +++ dao/FuldDaekningWorker/src/main/java/dk/daoas/fulddaekning/Database.java 2015/11/07 18:02:56 2770 @@ -206,6 +206,7 @@ /*String sql = "INSERT INTO fulddaekning.afstand_anden_rute_thn (orgId,orgPostnr, orgVejnavn,orgGadeid,orgHusnr,orgHusnrBogstav,orgLatitude,orgLongitude,orgRute,id,postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,rute,afstand,`timestamp`) "+ "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, now() )"; + PreparedStatement saveStmt = conn.prepareStatement(sql);*/ saveStmt.setInt(1, orgAdresse.id); @@ -248,6 +249,8 @@ protected ArrayList hentAdresseListe(PreparedStatement stmt) throws SQLException{ ArrayList list = new ArrayList( 1000000 ); + + Constants consts = Constants.getInstance(); //logger.info("Starting query"); ResultSet res = stmt.executeQuery(); @@ -274,6 +277,12 @@ list.add(adr); + if (consts.doCheckHO() == true && adr.ho == 0) { + System.out.println( "Mangler HO" ); + System.out.println( adr ); + System.exit(0); + } + //logger.info( "Adress:" + adr); }