3 Replies Latest reply on Sep 22, 2003 9:09 AM by Adrian Brock

    mysql and transaction

    osamu kaneko Newbie

      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.