[Solved] Re: Cron + HSQLDB: Unexpected token: in statement [SELECT 1]

[Andreas Hartmann]

Andreas Hartmann wrote:
Hi all,
I'm trying to run the cron block with the TX job store and the
built-in HSQL DB. My configurations:
<store delegate="org.quartz.impl.jdbcjobstore.HSQLDBDelegate" type="tx">
  <datasource provider="excalibur">LenyaScheduler</datasource>
</store>
<datasources>
  <jdbc logger="core.datasources.lenya.scheduler" name="LenyaScheduler">
    <pool-controller max="10" min="5"/>
    <dburl>jdbc:hsqldb:hsql://localhost:9002</dburl>
    <user>sa</user>
    <password/>
  </jdbc>
</datasources>
The problem is indeed that HSQL cannot parse the default keep-alive 
statement
"SELECT 1". But you can provide your own keep-alive statement:
    <jdbc logger="core.datasources.lenya.scheduler" name="LenyaScheduler">
      <pool-controller max="10" min="5">
        <!-- use custom keep-alive query because HSQL does not accept 'SELECT 
1' -->
        <keep-alive>SELECT 1 FROM QRTZ_LOCKS</keep-alive>
      </pool-controller>
      <dburl>jdbc:hsqldb:hsql://localhost:9002</dburl>
      <user>sa</user>
      <password/>
    </jdbc>

-- Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]