2 Replies Latest reply on Apr 19, 2003 3:11 PM by Dadure Arnaud

    MySQL and HyperSonicSQL

    Dadure Arnaud Newbie

      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/
      - i modify standardjaws.xml in conf/

      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 there a way to not use HypersonicSQL but MySQL ?

      thx

      Arnaud


        • 1. Re: MySQL and HyperSonicSQL
          Dadure Arnaud Newbie

          add-on... sorry

          - i modify standardjbosscmp-jdbc.xml in conf/
          by replace HypersonicSQL by MySQL

          - i modify standardjaws.xml in conf/
          by replace HypersonicSQL by MySQL


          thx

          • 2. Re: MySQL and HyperSonicSQL
            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