Mercurial > dive4elements > framework

annotate artifact-database/src/main/java/org/dive4elements/artifactdatabase/db/SQLExecutor.java @ 540:91b1435fb9ea

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added R/W lock to SQLExecutor.
author Sascha L. Teichmann <teichmann@intevation.de>
date Thu, 03 Sep 2015 11:46:24 +0200
parents 415df0fc4fa1
children 3b1e48d22ce0
rev   line source
475
415df0fc4fa1 Fixed maven group ids
Sascha L. Teichmann <teichmann@intevation.de>
parents: 473
diff changeset
1 package org.dive4elements.artifactdatabase.db;
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3 import java.sql.Connection;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4 import java.sql.PreparedStatement;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
5 import java.sql.ResultSet;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
6 import java.sql.SQLException;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
7
540
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
8 import java.util.concurrent.locks.ReentrantReadWriteLock;
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
9
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
10 import javax.sql.DataSource;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
11
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
12 import org.apache.log4j.Logger;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
13
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
14 public class SQLExecutor
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
15 {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
16 private static Logger logger = Logger.getLogger(SQLExecutor.class);
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
17
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
18 public class Instance {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
19
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
20 public Connection conn;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
21 public PreparedStatement stmnt;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
22 public ResultSet result;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
23
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
24 public Instance() {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
25 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
26
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
27 public void reset() throws SQLException {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
28 if (result != null) {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
29 result.close();
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
30 result = null;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
31 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
32 if (stmnt != null) {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
33 result = null;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
34 stmnt.close();
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
35 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
36 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
37
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
38 public PreparedStatement prepareStatement(String query)
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
39 throws SQLException {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
40 return stmnt = conn.prepareStatement(query);
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
41 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
42
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
43 public void close() {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
44 if (result != null) {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
45 try { result.close(); }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
46 catch (SQLException sqle) {}
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
47 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
48 if (stmnt != null) {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
49 try { stmnt.close(); }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
50 catch (SQLException sqle) {}
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
51 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
52 if (conn != null) {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
53 try { conn.close(); }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
54 catch (SQLException sqle) {}
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
55 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
56 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
57
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
58 public boolean runWrite() {
540
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
59 rwLock.writeLock().lock();
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
60 try {
540
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
61 DataSource dataSource = dbConnection.getDataSource();
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
62 try {
540
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
63 conn = dataSource.getConnection();
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
64 try {
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
65 conn.setAutoCommit(false);
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
66 return doIt();
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
67 }
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
68 catch (SQLException sqle) {
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
69 conn.rollback();
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
70 throw sqle;
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
71 }
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
72 }
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
73 catch (SQLException sqle) {
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
74 logger.error(sqle.getLocalizedMessage(), sqle);
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
75 }
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
76 finally {
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
77 close();
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
78 }
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
79 return false;
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
80 }
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
81 finally {
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
82 rwLock.writeLock().unlock();
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
83 }
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
84 }
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
85
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
86 public boolean runRead() {
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
87 rwLock.readLock().lock();
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
88 try {
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
89 DataSource dataSource = dbConnection.getDataSource();
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
90 try {
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
91 conn = dataSource.getConnection();
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
92 return doIt();
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
93 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
94 catch (SQLException sqle) {
540
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
95 logger.error(sqle.getLocalizedMessage(), sqle);
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
96 }
540
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
97 finally {
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
98 close();
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
99 }
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
100 return false;
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
101 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
102 finally {
540
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
103 rwLock.readLock().unlock();
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
104 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
105 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
106
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
107 public boolean doIt() throws SQLException {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
108 return true;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
109 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
110 } // class Instance
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
111
540
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
112 protected DBConnection dbConnection;
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
113 protected ReentrantReadWriteLock rwLock;
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
114
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
115 public SQLExecutor() {
540
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
116 rwLock = new ReentrantReadWriteLock();
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
117 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
118
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
119 public SQLExecutor(DBConnection dbConnection) {
540
91b1435fb9ea Added R/W lock to SQLExecutor.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 475
diff changeset
120 this();
305
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
121 this.dbConnection = dbConnection;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
122 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
123
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
124 public DBConnection getDBConnection() {
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
125 return dbConnection;
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
126 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
127 }
f33401ea2a6c Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
128 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :
http://dive4elements.wald.intevation.org