--- dao/FuldDaekningWorker/src/main/java/dk/daoas/fulddaekning/Database.java 2015/10/02 14:24:36 2740 +++ dao/FuldDaekningWorker/src/main/java/dk/daoas/fulddaekning/Database.java 2015/10/06 21:26:55 2741 @@ -68,6 +68,10 @@ } public void renameResultTables() throws SQLException { + if (LookupMain.test_mode == true) { + throw new RuntimeException("Can not rename tables in test mode"); + } + Constants consts = Constants.getInstance(); String ext = consts.getTableExtension(); @@ -106,7 +110,6 @@ "AND longitude IS NOT NULL " + "AND gadeid IS NOT NULL " + "AND (a.distributor IS NULL OR a.distributor<>'LUKKET') " - //"LIMIT 2500" ; if (LookupMain.test_mode == true) { @@ -164,6 +167,10 @@ "AND latitude IS NOT NULL " + "AND longitude IS NOT NULL " + "AND a.distributor = ? "; + + if (LookupMain.test_mode == true) { + sql = sql + " AND a.postnr BETWEEN 6000 and 7200 "; + } // Forward only + concur_read_only + fetchsize tvinger driver til at hente en række af gangen (bedre performance ved store result sets) // Se http://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html