-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
JBossAS-5.0.0.GA
-
None
After setting up Oracle10g as the DefaultDS using this docs: http://www.jboss.org/file-access/default/members/jbossas/freezone/docs/Installation_And_Getting_Started_Guide/5/html_single/index.html#Configuring_a_datasource_for_Oracle_DB
and starting the AS instance with "all" config, this error occured:
07:21:09,609 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)
...
-
-
- CONTEXTS IN ERROR: Name -> Error
-
jboss.ejb:service=EJB3TimerService -> 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
]]
It seems it fails due to trying to recover non-existing data from the database.
Similar failure occurs with PostgreSQL and DB2 v9.
- is incorporated by
-
EJBTHREE-1697 Move the current ejb3 timer service to a separate optional component
- Resolved
- is related to
-
JBAS-6305 Error installing KeyGeneratorFactory with some databases
- Closed
-
JBAS-6417 Move ejb3-timer-service.xml to docs/examples/ejb3
- Closed
- relates to
-
EJBTHREE-619 Build EJB Timer Service on top of Quartz
- Closed