[jboss-jira] [JBoss JIRA] Commented: (JBAS-6304) EJB3TimerService cannot start with some databases

EJB3TimerService cannot start with some databases ------------------------------------------------- Key: JBAS-6304 URL: https://jira.jboss.org/jira/browse/JBAS-6304 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: EJB3 Affects Versions: JBossAS-5.0.0.GA Environment: Oracle10g, PostgreSQL, DB2 v9, Sybase15 Reporter: Martin Malina Assignee: Carlo de Wolf Attachments: oracle10g.log, sybase15.log After setting up Oracle10g as the DefaultDS using this docs: http://www.jboss.org/file-access/default/members/jbossas/freezone/docs/In... 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.