0 Replies Latest reply on Dec 7, 2008 8:12 PM by ilango gurusamy

    which sql statements from tables_oracle.sql in quartz source

    ilango gurusamy Novice

      Hi
      I have configured JBoss 5 CR2 with Oracle 10g on a Windows XP machine
      In the process I added in SQL statements in ejb3-timer-service.xml

      Now on JBoss startup, I keep getting an messsage that said: sql failed: qrtz_job_details. So wonder if the rest of the statements from tables_oracle.sql need to be copied into ejb3-timer-service.xml as well before the create table statements.


      I copied over all the create table statements, but not the delete statements. But I see that in the docs/dbTables directory of my quartz source I also see the following:

      delete
      from qrtz_job_listeners;
      delete from qrtz_trigger_listeners;
      delete from qrtz_fired_triggers;
      delete
      from qrtz_simple_triggers;
      delete from qrtz_cron_triggers;
      delete from qrtz_blob_triggers;
      delete
      from qrtz_triggers;
      delete from qrtz_job_details;
      delete from qrtz_calendars;
      delete from
      qrtz_paused_trigger_grps;
      delete from qrtz_locks;
      delete from qrtz_scheduler_state;
      
      drop
      table qrtz_calendars;
      drop table qrtz_fired_triggers;
      drop table qrtz_trigger_listeners;
      drop
      table qrtz_blob_triggers;
      drop table qrtz_cron_triggers;
      drop table qrtz_simple_triggers;
      drop
      table qrtz_triggers;
      drop table qrtz_job_listeners;
      drop table qrtz_job_details;
      drop table
      qrtz_paused_trigger_g
       rps;
      drop table qrtz_locks;
      drop table qrtz_scheduler_state;


      thanks in advance