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

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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...