[jboss-user] [Installation, Configuration & DEPLOYMENT] - which sql statements from tables_oracle.sql in quartz source

[ilangocal]

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


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4194929#4194929

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4194929