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
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
