Re:HSQLDB - SQLException: Unexpected token , requires FROM in statement [select 0]

alexei — GMT

OK, thanks. It's work!

HSQLDB - SQLException: Unexpected token , requires FROM in statement [select 0]

alexei — GMT

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)

Messages posted by "alexei"

Re:HSQLDB - SQLException: Unexpected token , requires FROM in statement [select 0]

HSQLDB - SQLException: Unexpected token , requires FROM in statement [select 0]