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

[Martin Malina (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBAS-6304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Martin Malina updated JBAS-6304:
--------------------------------

    Attachment: oracle10g.log


Attached the server output.

> 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
>            Reporter: Martin Malina
>            Assignee: Carlo de Wolf
>         Attachments: oracle10g.log
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira