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

[André Ehrlich (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBAS-6304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12448015#action_12448015 ] 

André Ehrlich commented on JBAS-6304:
--------------------------------------

Hi Martin,

I faced the same issue, but it isn´t really a bug.

In your Oracle log, you can find the information:

   07:21:08,883 WARN  [QuartzTimerServiceFactory] sql failed: CREATE TABLE QRTZ_JOB_DETAILS(JOB_NAME VARCHAR(80) NOT NULL, JOB_GROUP VAR  [...]

which shows, that one of the tables required by the quartz framework could not be created. Please have a look in the file "ejb3-timer-service.xml" in folder "deploy". It defines the Timer Service MBean and contains an SQL script for creating the required tables. Unfortunately this script uses the SQL data type "BINARY", which is used by HSQLDB. To make it run with Oracle, you simply switch from "BINARY" to "BLOB".

cheers,
André

> 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/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.

-- 
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