diff backend/src/main/java/org/dive4elements/river/backend/SessionFactoryProvider.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 fdec8ab16fa7
children 026f4c684ee5
line wrap: on
line diff
--- a/backend/src/main/java/org/dive4elements/river/backend/SessionFactoryProvider.java	Thu Nov 06 15:16:37 2014 +0100
+++ b/backend/src/main/java/org/dive4elements/river/backend/SessionFactoryProvider.java	Wed Nov 12 13:31:53 2014 +0100
@@ -144,6 +144,10 @@
         if (connectionInitSqls != null) {
             props.setProperty("connectionInitSqls", connectionInitSqls);
         }
+        String validationQuery = credentials.getValidationQuery();
+        if (validationQuery != null) {
+            props.setProperty("validationQuery", validationQuery);
+        }
 
         cfg.mergeProperties(props);
 

http://dive4elements.wald.intevation.org