--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2014/09/11 14:46:59 2203 +++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2014/09/11 18:04:29 2210 @@ -122,7 +122,7 @@ return list; } - public ArrayList hentDaekkedeAdresser( BoundingBox bbox) throws SQLException { + public Adresse[] hentDaekkedeAdresser( BoundingBox bbox) throws SQLException { String sql = "SELECT id,postnr,adresse,gadeid,husnr,husnrbogstav,latitude,longitude,rute " + "FROM fulddaekning.adressetabel " + "WHERE rute IS NOT NULL " + @@ -142,7 +142,8 @@ stmt.setDouble(4, bbox.longitudeMax); stmt.setString(5, Lookup.distributor); - return hentAdresseListe( stmt ); + List list = hentAdresseListe( stmt ); + return list.toArray( new Adresse[ list.size() ] ); } @@ -187,7 +188,7 @@ protected ArrayList hentAdresseListe(PreparedStatement stmt) throws SQLException{ - ArrayList list = new ArrayList( 30000 ); + ArrayList list = new ArrayList( 1000000 ); //logger.info("Starting query"); ResultSet res = stmt.executeQuery();