Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/backend/src/main/java/org/dive4elements/river/backend/utils/DBCPConnectionProvider.java Thu Nov 06 15:16:37 2014 +0100 +++ b/backend/src/main/java/org/dive4elements/river/backend/utils/DBCPConnectionProvider.java Wed Nov 12 13:31:53 2014 +0100 @@ -211,6 +211,11 @@ StringTokenizer tokenizer = new StringTokenizer(connectionInitSqls, ";"); ds.setConnectionInitSqls(Collections.list(tokenizer)); } + + String validationQuery = props.getProperty("validationQuery"); + if (validationQuery != null) { + ds.setValidationQuery(validationQuery); + } // The BasicDataSource has lazy initialization // borrowing a connection will start the DataSource // and make sure it is configured correctly.