32 |
String sql = |
String sql = |
33 |
"SELECT id,vejnavn,husnr,husnrbogstav,kommunekode,vejkode,postnr,gadeid,upper(distributor) AS distributor,dbkbane,latitude,longitude, " |
"SELECT id,vejnavn,husnr,husnrbogstav,kommunekode,vejkode,postnr,gadeid,upper(distributor) AS distributor,dbkbane,latitude,longitude, " |
34 |
+ "rutema,korelistema,ruteti,korelisteti,ruteon,korelisteon,ruteto,korelisteto,rutefr,korelistefr,rutelo,korelistelo,ruteso,korelisteso " |
+ "rutema,korelistema,ruteti,korelisteti,ruteon,korelisteon,ruteto,korelisteto,rutefr,korelistefr,rutelo,korelistelo,ruteso,korelisteso " |
35 |
+ "FROM fulddaekning.adressetabel_beta " |
+ "FROM fulddaekning.adressetabel " |
36 |
+ "WHERE gadeid IS NOT NULL " |
+ "WHERE gadeid IS NOT NULL " |
37 |
+ debugFilter |
+ debugFilter |
38 |
; |
; |
39 |
|
|
40 |
|
|
41 |
try ( Connection conn = DBConnection.getConnection(); |
try ( Connection conn = DBConnection.getConnection(); |
42 |
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); |
Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); |
43 |
) { |
) { |
44 |
stmt.setFetchSize(Integer.MIN_VALUE); |
stmt.setFetchSize(Integer.MIN_VALUE); |
45 |
ResultSet res = stmt.executeQuery(sql); |
ResultSet res = stmt.executeQuery(sql); |
87 |
a.korelisteLordag = dirigeringsCache.getInstance( res.getString(24) ); |
a.korelisteLordag = dirigeringsCache.getInstance( res.getString(24) ); |
88 |
|
|
89 |
a.ruteSondag = dirigeringsCache.getInstance( res.getString(25) ); |
a.ruteSondag = dirigeringsCache.getInstance( res.getString(25) ); |
90 |
a.korelisteSondag = dirigeringsCache.getInstance( res.getString(16) ); |
a.korelisteSondag = dirigeringsCache.getInstance( res.getString(26) ); |
91 |
|
|
92 |
|
|
93 |
//Ajourfør adresse objectets dækningstype |
//Ajourfør adresse objectets dækningstype |
114 |
; |
; |
115 |
|
|
116 |
try ( Connection conn = DBConnection.getConnection(); |
try ( Connection conn = DBConnection.getConnection(); |
117 |
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); |
Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); |
118 |
) { |
) { |
119 |
|
|
120 |
stmt.setFetchSize(Integer.MIN_VALUE); |
stmt.setFetchSize(Integer.MIN_VALUE); |
166 |
; |
; |
167 |
|
|
168 |
try ( Connection conn = DBConnection.getConnection(); |
try ( Connection conn = DBConnection.getConnection(); |
169 |
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); |
Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); |
170 |
) { |
) { |
171 |
|
|
172 |
|
|