[jtrac-svn] SF.net SVN: j-trac:[1329] trunk/jtrac/src/main/java/info/jtrac/config/ JtracConfigurer.java

[<man...@us...>]

Revision: 1329
          http://j-trac.svn.sourceforge.net/j-trac/?rev=1329&view=rev
Author:   manfredwolff
Date:     2009-12-08 08:03:28 +0000 (Tue, 08 Dec 2009)

Log Message:
-----------
Changing the validation query from "SELECT 1" to "SELECT 1 FROM DUAL" for supporting Oracle. HSQLDB as well as MYSQL can deal with the different validation query.

Modified Paths:
--------------
    trunk/jtrac/src/main/java/info/jtrac/config/JtracConfigurer.java

Modified: trunk/jtrac/src/main/java/info/jtrac/config/JtracConfigurer.java
===================================================================
--- trunk/jtrac/src/main/java/info/jtrac/config/JtracConfigurer.java	2009-12-06 07:47:04 UTC (rev 1328)
+++ trunk/jtrac/src/main/java/info/jtrac/config/JtracConfigurer.java	2009-12-08 08:03:28 UTC (rev 1329)
@@ -193,7 +193,7 @@
         logger.info("jtrac.timestamp = '" + timestamp + "'");
         props.setProperty("jtrac.version", version);
         props.setProperty("jtrac.timestamp", timestamp);
-        props.setProperty("database.validationQuery", "SELECT 1");
+        props.setProperty("database.validationQuery", "SELECT 1 FROM DUAL");
         props.setProperty("ldap.url", "");
         props.setProperty("ldap.activeDirectoryDomain", "");
         props.setProperty("ldap.searchBase", "");


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.