Quartz JDBCJobstore doesn't work

Question

Hi

I have downloaded Quartz and I am trying to run a sample. I have a sample that uses JDBCJobStore which doesn't work but this sample works fine with RAMJobStore. Just when I choose JDBCJobStore and exception get raised. I am using quartz-1.6.5. please help me thanks

code:

package test;

import org.quartz.JobDetail;
import org.quartz.Scheduler;
import org.quartz.SchedulerException;
import org.quartz.SchedulerFactory;
import org.quartz.SimpleTrigger;
import org.quartz.Trigger;



public class ReportRunner {
    public static void main(String[] args) {
     try {

      SchedulerFactory schedFact = new org.quartz.impl.StdSchedulerFactory();
      Scheduler sched = schedFact.getScheduler();
      sched.start();

      JobDetail jobDetail = null;
      SimpleTrigger trigger2 = null;

      jobDetail = new JobDetail("Income Report", "Report Generation",
        QuartzReport.class);
      jobDetail.getJobDataMap().put("type", "FULL");
      jobDetail.setDurability(true);

      trigger2 = new SimpleTrigger("Income Report", "Report Generation");

      trigger2.setStartTime(new java.util.Date(
        System.currentTimeMillis() + 4000));
      trigger2.setRepeatInterval(5000);
      trigger2.setRepeatCount(100);
      sched.scheduleJob(jobDetail, trigger2);



     } catch (Exception e) {
      e.printStackTrace();
     }
    }

}

package test;

import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

public class QuartzReport implements Job {

    public void execute(JobExecutionContext cntxt) throws JobExecutionException {
     System.out.println("Generating report - "
       + cntxt.getJobDetail().getJobDataMap().get("type"));

    }
}

config file:

org.quartz.scheduler.instanceName = Sched1 org.quartz.scheduler.instanceId = 1 org.quartz.scheduler.rmi.export = false org.quartz.scheduler.rmi.proxy = false org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool org.quartz.threadPool.threadCount = 3 org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate org.quartz.jobStore.tablePrefix = QRTZ_ org.quartz.jobStore.dataSource = myDS org.quartz.dataSource.myDS.driver = com.mysql.jdbc.Driver org.quartz.dataSource.myDS.URL = jdbc:mysql://192.168.0.4:3306/conference org.quartz.dataSource.myDS.user = root org.quartz.dataSource.myDS.password =root org.quartz.dataSource.myDS.maxConnections 5

this the excpetion showd in runtime , it was logged

---

org.quartz.JobPersistenceException: Couldn't acquire next trigger: Field 'PRIORITY' doesn't have a default value [See nested exception: java.sql.SQLException: Field 'PRIORITY' doesn't have a default value] at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:1778) at org.quartz.impl.jdbcjobstore.JobStoreTX.acquireNextTrigger(JobStoreTX.java:1218) at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233) * Nested Exception (Underlying Cause) --------------- java.sql.SQLException: Field 'PRIORITY' doesn't have a default value at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertFiredTrigger(StdJDBCDelegate.java:3360) at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:1771) at org.quartz.impl.jdbcjobstore.JobStoreTX.acquireNextTrigger(JobStoreTX.java:1218) at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233) 547 [QuartzScheduler_MyClusteredScheduler-NON_CLUSTERED_MisfireHandler] DEBUG org.quartz.impl.jdbcjobstore.SimpleSemaphore - Lock 'TRIGGER_ACCESS' retuned by: QuartzScheduler_MyClusteredScheduler-NON_CLUSTERED_MisfireHandler

Answer 1

I tried with Quartz 1.6.5 and I did't found any result, but it with with Quartz 1.5., I guess there might be some bug in 1.6.5 for JDBC jobstore. Mohammad

Answer 2

java.sql.SQLException: Field 'PRIORITY' doesn't have a default value

I guess you can tell where the problem lies by seeing the exception above.