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