Hi.I'm using version, jboss-3.2.1_tomcat-4.1.24.
DB is changed to Mysql from hypersonic.
The problem is, when I use transaction, jboss try to issue following SQLs.
--------------------------------------------
SET autocommit=0
CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )
CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER )
DELETE FROM JMS_MESSAGES WHERE TXID IN (SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'
rollback
SET autocommit=1
------------------------------------------------------
In the "CREATE TABLE JMS_MESSAGES ..", column "MESSAGEBLOB OBJECT" dose not accept by mysql. mysql dose not support object type.
Anybody has a solution??? thank you.