I try to use the EJB3 timer service with Oracle DS.
First of all I have to use a non XA connection, is the XA protocol not needed?
If I use a local-tx-datasource the table can not created because of an illegal data type.
The Statement:
anonymous wrote : 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 BINARY NULL, PRIMARY KEY
(JOB_NAME,JOB_GROUP))
will not work. The type BINARY is not valid for Oracle.
Do I have to patch the ejb3-timer-service.xml if I change the DB for it or is there a
configuration for the different DB types?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4174286#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...