--- dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayer.java 2015/03/24 11:05:24 2489 +++ dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayer.java 2015/05/11 08:05:01 2539 @@ -59,7 +59,7 @@ a.kommunekode = (short) res.getInt(5); a.vejkode = (short)res.getInt(6); a.postnr = (short)res.getInt(7); - a.gadeid = res.getLong(8); + a.gadeid = res.getInt(8); a.distributor = distributorCache.getInstance(res.getString(9)); a.dbkBane = (short) res.getInt(10); a.koreliste = korelisteCache.getInstance( res.getString(11) ); @@ -108,7 +108,7 @@ while (res.next()) { AliasBean ab = new AliasBean(); - ab.postnr = res.getInt(1); + ab.postnr = res.getShort(1); ab.vejnavn = vejCache.getInstance( res.getString(2) ); ab.aliasVejnavn = vejCache.getInstance( res.getString(3) ); @@ -175,7 +175,7 @@ } } - public static Map get100PctList() throws SQLException { + public static Map get100PctList() throws SQLException { String sql = "SELECT postnr,UPPER(distributor) as distributor,rute,koreliste,dbkbane " + "FROM bogleveringer.adresser_udenfor_daekning"; @@ -184,7 +184,7 @@ ) { ResultSet res = stmt.executeQuery(sql); - Map map = new HashMap(); + Map map = new HashMap(); DeduplicateHelper distributorCache = new DeduplicateHelper(); @@ -192,7 +192,7 @@ HundredePctBean bean = new HundredePctBean(); - bean.postnr = res.getInt(1); + bean.postnr = (short) res.getInt(1); bean.distributor = distributorCache.getInstance(res.getString(2)); bean.rute = res.getString(3); bean.koreliste = res.getString(4);