After unzipping the archive I modified ejb3-timer-service.xml. There was no
problem (changes see below). However, I get these error messages in the
PostgreSQL console regarding JMS.
ERROR: syntax error at or near "(" at character 74
| STATEMENT: CREATE TABLE JMS_TRANSACTION (TRANSACTIONID BIGINT, BRANCH_QUAL
VARBINARY(254), FORMAT_ID INTEGER, GLOBAL_TXID VARBINARY(254), PRIMARY KEY
(TRANSACTIONID))
|
| ERROR: syntax error at or near "(" at character 283
| STATEMENT: CREATE TABLE JMS_MESSAGE (MESSAGEID BIGINT, RELIABLE CHAR(1),
EXPIRATION BIGINT, TIMESTAMP BIGINT, PRIORITY TINYINT, COREHEADERS
LONGVARBINARY, PAYLOAD LONGVARBINARY, CHANNELCOUNT INTEGER, TYPE TINYINT,
JMSTYPE VARCHAR(255), CORRELATIONID VARCHAR(255), CORRELATIONID_BYTES
VARBINARY(254), DESTINATION_ID BIGINT, REPLYTO_ID BIGINT, JMSPROPERTIES
LONGVARBINARY, PRIMARY KEY (MESSAGEID))
Where can I find these table definitions in 5.0beta1? Any hint is appreciated!
Changes made in ejb3-timer-service.xml:
HSQLDBDelegate -> PostgreSQLDelegate
| qrtz_job_details: BINARY -> oid
| qrtz_triggers: BINARY -> oid
| IS_VOLATILE VARCHAR(1) -> IS_VOLATILE boolean
| qrtz_blob_triggers: BINARY -> oid
| qrtz_calendars: BINARY -> oid
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3994145#3994145
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3994145
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
