You are viewing a plain text version of this content. The canonical link for it is here.
Posted to scm@geronimo.apache.org by ga...@apache.org on 2008/01/16 20:29:30 UTC

svn commit: r612549 - /geronimo/server/trunk/applications/monitoring/agent-ds/src/main/plan/plan.xml

Author: gawor
Date: Wed Jan 16 11:29:30 2008
New Revision: 612549

URL: http://svn.apache.org/viewvc?rev=612549&view=rev
Log:
fixed the test query to see if the db tables are already there

Modified:
    geronimo/server/trunk/applications/monitoring/agent-ds/src/main/plan/plan.xml

Modified: geronimo/server/trunk/applications/monitoring/agent-ds/src/main/plan/plan.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/applications/monitoring/agent-ds/src/main/plan/plan.xml?rev=612549&r1=612548&r2=612549&view=diff
==============================================================================
--- geronimo/server/trunk/applications/monitoring/agent-ds/src/main/plan/plan.xml (original)
+++ geronimo/server/trunk/applications/monitoring/agent-ds/src/main/plan/plan.xml Wed Jan 16 11:29:30 2008
@@ -68,14 +68,14 @@
     
     <!-- These two GBeans will create the tables for the database automatically -->
     <gbean name="ActiveDSGBean" class="org.apache.geronimo.connector.DatabaseInitializationGBean">
-        <attribute name="testSQL">SELECT t.tablename FROM SYS.SYSTABLES t WHERE t.tablename='Statistics'</attribute>
+        <attribute name="testSQL">SELECT t.tablename FROM SYS.SYSTABLES t WHERE lower(t.tablename)='statistics'</attribute>
         <attribute name="path">META-INF/database/derby/createTables.sql</attribute>
         <reference name="DataSource">
             <name>jdbc/ActiveDS</name>
         </reference>
     </gbean>
     <gbean name="ArchiveDSGBean" class="org.apache.geronimo.connector.DatabaseInitializationGBean">
-	    <attribute name="testSQL">SELECT t.tablename FROM SYS.SYSTABLES t WHERE t.tablename='Statistics'</attribute>
+	    <attribute name="testSQL">SELECT t.tablename FROM SYS.SYSTABLES t WHERE lower(t.tablename)='statistics'</attribute>
 	    <attribute name="path">META-INF/database/derby/createTables.sql</attribute>
 	    <reference name="DataSource">
 	        <name>jdbc/ArchiveDS</name>