[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: Configuring ejb3-timer-service.xml (JBoss 5.0.0.CR1)

[abhinav.ind]

Hi
i am getting the same exception, tried things u hav mentioned above but didnt work out for me. i am using oracle. i changed the dialect and scripts.
here is the log :

08:43:15,604 INFO  [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
08:43:15,619 INFO  [RAMJobStore] RAMJobStore initialized.
08:43:15,619 INFO  [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
08:43:15,619 INFO  [StdSchedulerFactory] Quartz scheduler version: 1.5.2
08:43:15,619 INFO  [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
08:43:15,807 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=myDB' to JNDI name 'java:myDB'
08:43:17,136 WARN  [QuartzTimerServiceFactory] sql failed: CREATE TABLE qrtz_job_details
08:43:17,167 INFO  [SimpleThreadPool] Job execution threads will use class loader of thread: main
08:43:17,167 INFO  [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
08:43:17,167 INFO  [JobStoreCMT] Using db table-based data access locking (synchronization).
08:43:17,183 ERROR [AbstractKernelController] Error installing to Start: name=jboss.ejb:service=EJB3TimerService state=Create mode=Manual requiredState=Installed
org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-00942: table or view does not exist
 [See nested exception: java.sql.SQLException: ORA-00942: table or view does not exist
]]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493)
	at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144)
	at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010)
	at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152)
	at org.jboss.ejb3.timerservice.quartz.QuartzTimerServiceFactory.start(QuartzTimerServiceFactory.java:258)
	at org.jboss.ejb3.timerservice.quartz.jmx.EJB3TimerService.startService(EJB3TimerService.java:105)

kindly help....

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

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