[
https://jira.jboss.org/jira/browse/JBAS-6304?page=com.atlassian.jira.plug...
]
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/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.
--
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