--- dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java 2015/02/17 08:19:16 2317 +++ dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java 2015/02/17 08:27:13 2318 @@ -102,13 +102,19 @@ ResultSet res = stmt.executeQuery(sql); + DeduplicateHelper transportTyper = new DeduplicateHelper(); + List list = new ArrayList( 350000); //Initial capacity 350K while (res.next()) { + + String dbTransport = res.getString(4); + String transport = transportTyper.getInstance(dbTransport); + ExtendedBean eb = new ExtendedBean(); eb.orgId = res.getInt(1); eb.targetId = res.getInt(2); eb.afstand = res.getDouble(3); - eb.transport = res.getString(4); + eb.transport = transport; list.add(eb); }