--- dao/DaoAdresseVedligehold/src/main/java/dk/daoas/adressevedligehold/db/DatabaseCoverageUpdate.java 2016/09/09 08:58:41 3110 +++ dao/DaoAdresseVedligehold/src/main/java/dk/daoas/adressevedligehold/db/DatabaseCoverageUpdate.java 2016/09/09 09:26:55 3111 @@ -67,7 +67,9 @@ DeduplicateHelper vejnavnCache = new DeduplicateHelper(81920); DeduplicateHelper husnrbogstavCache = new DeduplicateHelper(); DeduplicateHelper distributorCache = new DeduplicateHelper(); - DeduplicateHelper dirigeringsCache = new DeduplicateHelper(16*1024); + DeduplicateHelper dirigeringsCache = new DeduplicateHelper(16*1024); + + DeduplicateHelper baneCache = new DeduplicateHelper(); while (res.next()) { @@ -82,7 +84,7 @@ a.postnr = (short)res.getInt(7); a.gadeid = res.getInt(8); a.distributor = distributorCache.getInstance(res.getString(9)); - a.dbkBane = (short) res.getInt(10); + a.dbkBane = baneCache.getInstance(res.getString(10)); a.latitude = (float) res.getDouble(11); a.longitude = (float) res.getDouble(12); @@ -143,7 +145,7 @@ stmt.setShort(5, addr.vejkode); stmt.setShort(6, addr.postnr); stmt.setInt(7, addr.gadeid); - stmt.setShort(8, addr.dbkBane); + stmt.setString(8, addr.dbkBane); stmt.setString(9, david); stmt.setString(10, addr.ruteMandag); @@ -224,7 +226,7 @@ stmt.setString(15, addr.korelisteSondag); stmt.setString(16, addr.distributor); - stmt.setInt(17, addr.dbkBane); + stmt.setString(17, addr.dbkBane);