1 Reply Latest reply on Apr 19, 2003 3:13 PM by Dadure Arnaud

    JMS, HypersonicSQL and MySQL

    Dadure Arnaud Newbie

      First, i have already post those questions in another forum (DataSource) because the subjects are in both...

      I use JBoss 3.2 / Tomcat 4.1.24 on windows with Mysql 4.0.10-max-nt

      I do not succed in totaly replace HyperSonicSQL by MySQL in JBoss (see other topic last day) so i try another way...

      - i put the mysql-ds.xml in deploy/
      - i modify standardjbosscmp-jdbc.xml in conf/ by replacing HyperSonicSQL by MySQL
      - i modify standardjaws.xml in conf/ by replacing HyperSonicSQL by MySQL

      and that's all....

      after that i was able to start without ERROR, i suppose JMS in JBoss still using HypersonicSQL and i was able to deploy Entity Beans using mysql automaticaly...

      my questions are...

      - is it correct installation ?
      - what about JMS (i will use it) in HyperSonicSQL ? is it worknig well ?
      - is there a way to not use HypersonicSQL but MySQL ?

      thx

      Arnaud


        • 1. Re: JMS, HypersonicSQL and MySQL
          Dadure Arnaud Newbie

          Allen Johnson give me the solution :))

          In fact when you want to use MySQL alone without HypersonicSQL, JMS in JBoss try to create 2 tables, but fail because syntax errors...
          use :

          CREATE TABLE JMS_MESSAGES
          (
          MESSAGEID INTEGER NOT NULL,
          DESTINATION VARCHAR(255) NOT NULL,
          TXID INTEGER,
          TXOP CHAR(1),
          MESSAGEBLOB BLOB,
          PRIMARY KEY (MESSAGEID, DESTINATION)
          );

          CREATE TABLE JMS_TRANSACTIONS
          (
          TXID INTEGER
          );


          to manually create those tables... and then move away HypersonicSQL... it works... :)

          thx to Allen

          Arnaud