Commits

timemachine committed e360931

Updated oracle validation query.

Comments (0)

Files changed (3)

timemachine-hibernate/config/scheduler-oracle-node1.properties

 timemachine.scheduler.dataStore.hibernateDataStore.hibernate.show_sql = false
 timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.min_size=1
 timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.max_size=5
-timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.preferredTestQuery=SELECT 1
+timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.preferredTestQuery=SELECT 1 FROM DUAL

timemachine-hibernate/config/scheduler-oracle-node2.properties

 timemachine.scheduler.dataStore.hibernateDataStore.hibernate.show_sql = false
 timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.min_size=1
 timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.max_size=5
-timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.preferredTestQuery=SELECT 1
+timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.preferredTestQuery=SELECT 1 FROM DUAL

timemachine-hibernate/config/scheduler-oracle-node3.properties

 timemachine.scheduler.dataStore.hibernateDataStore.hibernate.show_sql = false
 timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.min_size=1
 timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.max_size=5
-timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.preferredTestQuery=SELECT 1
+timemachine.scheduler.dataStore.hibernateDataStore.hibernate.c3p0.preferredTestQuery=SELECT 1 FROM DUAL