Terracotta Discussion Forums

OK, thanks. It's work!

I'm using quartz 2.1, java 1.6 and MySQL.
my quartz.properties for MySQL (piece)
Code:

 org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreTX
 org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
 org.quartz.jobStore.useProperties=false
 org.quartz.jobStore.dataSource=myDS
 org.quartz.jobStore.tablePrefix=QRTZ_
 org.quartz.jobStore.isClustered=false
 
 #============================================================================
 # Configure Datasources  
 #============================================================================
 
 org.quartz.dataSource.myDS.driver=org.gjt.mm.mysql.Driver
 org.quartz.dataSource.myDS.URL=jdbc:mysql://myIP:3306/myProj
 org.quartz.dataSource.myDS.user=myUser
 org.quartz.dataSource.myDS.password=myPass
 org.quartz.dataSource.myDS.maxConnections=5
 org.quartz.dataSource.myDS.validationQuery=select 0

and it's work fine!
But I want to switch DB from MySQL to HSQLDB.

Here quartz.properties (piece) for HSQLDB:
Code:

 org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreTX
 org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.HSQLDBDelegate
 org.quartz.jobStore.useProperties=false
 org.quartz.jobStore.dataSource=myDS
 org.quartz.jobStore.tablePrefix=QRTZ_
 org.quartz.jobStore.isClustered=false
 
 #============================================================================
 # Configure Datasources  
 #============================================================================
 
 org.quartz.dataSource.myDS.driver=org.hsqldb.jdbcDriver
 org.quartz.dataSource.myDS.URL=jdbc:hsqldb:file:d:/db/myProj
 org.quartz.dataSource.myDS.user=SA
 org.quartz.dataSource.myDS.password=
 org.quartz.dataSource.myDS.maxConnections=5
 org.quartz.dataSource.myDS.validationQuery=select 0

When I start application I get the next error:

Code:

 DEBUG: 18.12.2011 16:10:31.270 com.mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable(NewPooledConnection.java:367) 
     com.mchange.v2.c3p0.impl.NewPooledConnection@12fb063 handling a throwable.
 java.sql.SQLException: Unexpected token , requires FROM in statement [select 0]
 	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
 	at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
 	at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
 	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
 	at com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:73)
 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:374)
 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.finerLoggingTestPooledConnection(C3P0PooledConnectionPool.java:318)
 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.refurbishResourceOnCheckin(C3P0PooledConnectionPool.java:299)
 	at com.mchange.v2.resourcepool.BasicResourcePool.attemptRefurbishResourceOnCheckin(BasicResourcePool.java:1606)
 	at com.mchange.v2.resourcepool.BasicResourcePool.access$200(BasicResourcePool.java:32)
 	at com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask.run(BasicResourcePool.java:1228)
 	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)