Terracotta Discussion Forums

Am new to this topic, now i am implements this, please guide me.

am creating the quartz JDBC job store tables in my database, but how to implement to this tables.

actually am sending the sms job scheduling for using cron trigger, but i dont know correct logic, please any one send me some example code.

SQL to create DB tables for many different databases is provided with Quartz full distribution under /docs/dbtables. (not sure if location changed with new quartz 2.0 version)

1. You need to set your "jobStore" to be JDBC jobstore (instead of in-memory RAMJobStore).
2. You need to specify the correct delegate for your database.

For example, this is provided on quartz properties to specify I want to use JDBC Store (Oracle) with container managed transaction (CMT) and the corresponding delegate:

Code:

org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreCMT
 org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.oracle.OracleDelegate

Note: For Quartz managed transactions there is a JobStoreTX.

Take some time to go over the documentation as it is pretty good and much more detailed than any quick advice you might get here.

For explanation about using persistent JobStore look under JDBC-JobStore and Datasource section at: http://www.quartz-scheduler.org/docs/tutorial/TutorialLesson09.html

For details in configuration and properties look at: http://www.quartz-scheduler.org/docs/configuration/index.html

The links provided are for Quartz 2.0 but comparable documentation exists for Quartz 1.x

Let us know if you have any issues implementing it.

nicolas.loriente

I having a testing for this now......

but found a bug

This is an old thread and no update from a long time.Please let us know if you are still facing same issue.
Thanks