[JBoss-dev] Quartz MBean

[Sacha Labourey]

In JBoss HEAD, it seems there is a problem with the Quartz MBean, a
fresh start gives this:

17:34:39,468 INFO  [WrapperDataSourceService] Bound ConnectionManager
'jboss.jca
:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
17:34:39,734 WARN  [TimerServiceFactory] sql failed: CREATE TABLE
qrtz_job_detai
ls(JOB_NAME VARCHAR(80) NOT NULL, JOB_GROUP VARCHAR(80) NOT NULL,
DESCRIPTION VA
RCHAR(120) NULL, JOB_CLASS_NAME VARCHAR(128) NOT NULL, IS_DURABLE
VARCHAR(1) NOT
NULL, IS_VOLATILE VARCHAR(1) NOT NULL, IS_STATEFUL VARCHAR(1) NOT NULL,
REQUEST
S_RECOVERY VARCHAR(1) NOT NULL, JOB_DATA BINARY NULL, PRIMARY KEY
(JOB_NAME,JOB_
GROUP))
java.sql.SQLException: Table already exists: QRTZ_JOB_DETAILS in
statement [CREA
TE TABLE qrtz_job_details]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source)
        at
org.jboss.resource.adapter.jdbc.CachedPreparedStatement.execute(Cache
dPreparedStatement.java:216)
        at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(Wrap
pedPreparedStatement.java:209)
        at
org.jboss.ejb3.timerservice.TimerServiceFactory.execute(TimerServiceF
actory.java:170)
        at
org.jboss.ejb3.timerservice.TimerServiceFactory.createSchema(TimerSer
viceFactory.java:86)
        at
org.jboss.ejb3.timerservice.TimerServiceFactory.start(TimerServiceFac
tory.java:241)
        at
org.jboss.ejb3.timerservice.jmx.EJB3TimerService.startService(EJB3Tim
erService.java:105)
        at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS