17 |
import dk.daoas.adressevedligehold.util.TimingHelper; |
import dk.daoas.adressevedligehold.util.TimingHelper; |
18 |
|
|
19 |
/* |
/* |
20 |
* TODO: Batched skrivning af updates |
* TODO: Batched skrivning af updates |
|
* TODO: Skrivning af nye adresser |
|
21 |
* |
* |
22 |
*/ |
*/ |
23 |
|
|
24 |
public class DatabaseLayerImplementation { |
public class DatabaseCoverageUpdate { |
25 |
|
|
26 |
//static boolean DEBUG = false; |
//static boolean DEBUG = false; |
27 |
|
|
41 |
; |
; |
42 |
|
|
43 |
try ( Connection conn = DBConnection.getConnection(); |
try ( Connection conn = DBConnection.getConnection(); |
44 |
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); |
45 |
) { |
) { |
46 |
stmt.setFetchSize(Integer.MIN_VALUE); |
stmt.setFetchSize(Integer.MIN_VALUE); |
47 |
ResultSet res = stmt.executeQuery(sql); |
ResultSet res = stmt.executeQuery(sql); |
209 |
|
|
210 |
stmt.execute(); |
stmt.execute(); |
211 |
if (stmt.getUpdateCount() != 1) { |
if (stmt.getUpdateCount() != 1) { |
212 |
System.out.println("Error executing update"); |
logger.warning("Error executing update: " + addr); |
213 |
} |
} |
214 |
|
|
215 |
} |
} |