Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/backend/utils/DBCPConnectionProvider.java @ 8470:c5a7aae52396
Added a validation SQL query to database backends.
Enable it by storing something like "SELECT 1 FROM DUAL" in config
under /artifact-database/backend-database/validation-query/text()
or /artifact-database/seddb-database/validation-query/text().
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Wed, 12 Nov 2014 13:31:53 +0100 |
| parents | 3bb1c62ad732 |
| children | 7dd39219bd68 |
comparison
equal
deleted
inserted
replaced
| 8469:079147282650 | 8470:c5a7aae52396 |
|---|---|
| 209 String connectionInitSqls = props.getProperty("connectionInitSqls"); | 209 String connectionInitSqls = props.getProperty("connectionInitSqls"); |
| 210 if (connectionInitSqls != null) { | 210 if (connectionInitSqls != null) { |
| 211 StringTokenizer tokenizer = new StringTokenizer(connectionInitSqls, ";"); | 211 StringTokenizer tokenizer = new StringTokenizer(connectionInitSqls, ";"); |
| 212 ds.setConnectionInitSqls(Collections.list(tokenizer)); | 212 ds.setConnectionInitSqls(Collections.list(tokenizer)); |
| 213 } | 213 } |
| 214 | |
| 215 String validationQuery = props.getProperty("validationQuery"); | |
| 216 if (validationQuery != null) { | |
| 217 ds.setValidationQuery(validationQuery); | |
| 218 } | |
| 214 // The BasicDataSource has lazy initialization | 219 // The BasicDataSource has lazy initialization |
| 215 // borrowing a connection will start the DataSource | 220 // borrowing a connection will start the DataSource |
| 216 // and make sure it is configured correctly. | 221 // and make sure it is configured correctly. |
| 217 | 222 |
| 218 // Connection conn = ds.getConnection(); | 223 // Connection conn = ds.getConnection(); |