[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Create table warning... Need help!
ablegreen27
do-not-reply at jboss.com
Wed Feb 11 17:50:40 EST 2009
In case anyone can glean any insights into
my existing ejb3-timer-service.xml file, I
provide a copy of it below. If anyone
identifies a problem, please let me know!
As a note, it has been altered to support
MySQL with JBoss AS 5.0.0.GA.
Thanks again in advance.
| <?xml version="1.0" encoding="UTF-8"?>
| <server>
| <!-- TODO: the ejb deployer must depend on this -->
|
| <!-- ================================================ -->
| <!-- Defines the Quartz configuration for -->
| <!-- the EJB3 Timer Service -->
| <!-- ================================================ -->
| <mbean code="org.jboss.ejb3.timerservice.quartz.jmx.EJB3TimerService"
| name="jboss.ejb:service=EJB3TimerService">
| <depends>jboss:service=Naming</depends>
| <depends>jboss:service=TransactionManager</depends>
| <depends optional-attribute-name="DataSource">
| jboss.jca:service=DataSourceBinding,name=DefaultDS
| </depends>
|
| <attribute name="Properties">
| org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreCMT
| org.quartz.jobStore.nonManagedTXDataSource=myDS
| org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
| org.quartz.jobStore.tablePrefix=QRTZ_
| org.quartz.jobStore.dataSource=myDS
|
| # To get it to work with hypersonic
| # FIXME: this doesn't lock the row
| org.quartz.jobStore.selectWithLockSQL=SELECT * FROM QRTZ_LOCKS WHERE lock_name = ?
|
| # from quartz.properties
| org.quartz.scheduler.instanceName=JBossEJB3QuartzScheduler
| org.quartz.scheduler.rmi.export=false
| org.quartz.scheduler.rmi.proxy=false
| org.quartz.scheduler.wrapJobExecutionInUserTransaction=false
|
| org.quartz.threadPool.class=org.quartz.simpl.SimpleThreadPool
| org.quartz.threadPool.threadCount=10
| org.quartz.threadPool.threadPriority=5
| org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread=true
|
| org.quartz.jobStore.misfireThreshold=60000
| </attribute>
| <attribute name="SqlProperties">
| CREATE_DB_ON_STARTUP = TRUE
|
| CREATE_TABLE_JOB_DETAILS = \
| CREATE TABLE QRTZ_JOB_DETAILS \
| ( \
| JOB_NAME VARCHAR(80) NOT NULL, \
| JOB_GROUP VARCHAR(80) NOT NULL, \
| DESCRIPTION VARCHAR(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, \
| REQUESTS_RECOVERY VARCHAR(1) NOT NULL, \
| JOB_DATA BLOB NULL, \
| PRIMARY KEY (JOB_NAME,JOB_GROUP) \
| )
| CREATE_TABLE_JOB_LISTENERS = \
| CREATE TABLE QRTZ_JOB_LISTENERS \
| ( \
| JOB_NAME VARCHAR(80) NOT NULL, \
| JOB_GROUP VARCHAR(80) NOT NULL, \
| JOB_LISTENER VARCHAR(80) NOT NULL, \
| PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER), \
| FOREIGN KEY (JOB_NAME,JOB_GROUP) \
| REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) \
| )
| CREATE_TABLE_TRIGGERS = \
| CREATE TABLE QRTZ_TRIGGERS \
| ( \
| TRIGGER_NAME VARCHAR(80) NOT NULL, \
| TRIGGER_GROUP VARCHAR(80) NOT NULL, \
| JOB_NAME VARCHAR(80) NOT NULL, \
| JOB_GROUP VARCHAR(80) NOT NULL, \
| IS_VOLATILE VARCHAR(1) NOT NULL, \
| DESCRIPTION VARCHAR(120) NULL, \
| NEXT_FIRE_TIME BIGINT(13) NULL, \
| PREV_FIRE_TIME BIGINT(13) NULL, \
| TRIGGER_STATE VARCHAR(16) NOT NULL, \
| TRIGGER_TYPE VARCHAR(8) NOT NULL, \
| START_TIME BIGINT(13) NOT NULL, \
| END_TIME BIGINT(13) NULL, \
| CALENDAR_NAME VARCHAR(80) NULL, \
| MISFIRE_INSTR SMALLINT(2) NULL, \
| JOB_DATA BLOB NULL, \
| PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP), \
| FOREIGN KEY (JOB_NAME,JOB_GROUP) \
| REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) \
| )
| CREATE_TABLE_SIMPLE_TRIGGERS = \
| CREATE TABLE QRTZ_SIMPLE_TRIGGERS \
| ( \
| TRIGGER_NAME VARCHAR(80) NOT NULL, \
| TRIGGER_GROUP VARCHAR(80) NOT NULL, \
| REPEAT_COUNT BIGINT(7) NOT NULL, \
| REPEAT_INTERVAL BIGINT(12) NOT NULL, \
| TIMES_TRIGGERED BIGINT(7) NOT NULL, \
| PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP), \
| FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) \
| REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP) \
| )
| CREATE_TABLE_CRON_TRIGGERS = \
| CREATE TABLE QRTZ_CRON_TRIGGERS \
| ( \
| TRIGGER_NAME VARCHAR(80) NOT NULL, \
| TRIGGER_GROUP VARCHAR(80) NOT NULL, \
| CRON_EXPRESSION VARCHAR(80) NOT NULL, \
| TIME_ZONE_ID VARCHAR(80), \
| PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP), \
| FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) \
| REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP) \
| )
| CREATE_TABLE_BLOB_TRIGGERS = \
| CREATE TABLE QRTZ_BLOB_TRIGGERS \
| ( \
| TRIGGER_NAME VARCHAR(80) NOT NULL, \
| TRIGGER_GROUP VARCHAR(80) NOT NULL, \
| BLOB_DATA BLOB NULL, \
| PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP), \
| FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) \
| REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP) \
| )
| CREATE_TABLE_TRIGGER_LISTENERS = \
| CREATE TABLE QRTZ_TRIGGER_LISTENERS \
| ( \
| TRIGGER_NAME VARCHAR(80) NOT NULL, \
| TRIGGER_GROUP VARCHAR(80) NOT NULL, \
| TRIGGER_LISTENER VARCHAR(80) NOT NULL, \
| PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER), \
| FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) \
| REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP) \
| )
| CREATE_TABLE_CALENDARS = \
| CREATE TABLE QRTZ_CALENDARS \
| ( \
| CALENDAR_NAME VARCHAR(80) NOT NULL, \
| CALENDAR BLOB NOT NULL, \
| PRIMARY KEY (CALENDAR_NAME) \
| )
| CREATE_TABLE_PAUSED_TRIGGER_GRPS = \
| CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS \
| ( \
| TRIGGER_GROUP VARCHAR(80) NOT NULL, \
| PRIMARY KEY (TRIGGER_GROUP) \
| )
| CREATE_TABLE_FIRED_TRIGGERS = \
| CREATE TABLE QRTZ_FIRED_TRIGGERS \
| ( \
| ENTRY_ID VARCHAR(95) NOT NULL, \
| TRIGGER_NAME VARCHAR(80) NOT NULL, \
| TRIGGER_GROUP VARCHAR(80) NOT NULL, \
| IS_VOLATILE VARCHAR(1) NOT NULL, \
| INSTANCE_NAME VARCHAR(80) NOT NULL, \
| FIRED_TIME BIGINT(13) NOT NULL, \
| STATE VARCHAR(16) NOT NULL, \
| JOB_NAME VARCHAR(80) NULL, \
| JOB_GROUP VARCHAR(80) NULL, \
| IS_STATEFUL VARCHAR(1) NULL, \
| REQUESTS_RECOVERY VARCHAR(1) NULL, \
| PRIMARY KEY (ENTRY_ID) \
| )
| CREATE_TABLE_SCHEDULER_STATE = \
| CREATE TABLE QRTZ_SCHEDULER_STATE \
| ( \
| INSTANCE_NAME VARCHAR(80) NOT NULL, \
| LAST_CHECKIN_TIME BIGINT(13) NOT NULL, \
| CHECKIN_INTERVAL BIGINT(13) NOT NULL, \
| RECOVERER VARCHAR(80) NULL, \
| PRIMARY KEY (INSTANCE_NAME) \
| )
| CREATE_TABLE_LOCKS = \
| CREATE TABLE QRTZ_LOCKS \
| ( \
| LOCK_NAME VARCHAR(40) NOT NULL, \
| PRIMARY KEY (LOCK_NAME) \
| )
| INSERT_TRIGGER_ACCESS = \
| INSERT INTO QRTZ_LOCKS values('TRIGGER_ACCESS')
| INSERT_JOB_ACCESS = \
| INSERT INTO QRTZ_LOCKS values('JOB_ACCESS')
| INSERT_CALENDAR_ACCESS = \
| INSERT INTO QRTZ_LOCKS values('CALENDAR_ACCESS')
| INSERT_STATE_ACCESS = \
| INSERT INTO QRTZ_LOCKS values('STATE_ACCESS')
| INSERT_MISFIRE_ACCESS = \
| INSERT INTO QRTZ_LOCKS values('MISFIRE_ACCESS')
| </attribute>
| </mbean>
| </server>
|
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4209281#4209281
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4209281
More information about the jboss-user
mailing list