4 Replies Latest reply on Mar 21, 2009 3:02 PM by oneclic.mohsen_med2003.yahoo.fr

    HSQL to MYSQL

    standup

      Hy all,


      I'm a newbie in Seam. I tried to change an example from Seam Framework by using mysql instead of hsql. I pick up the registration example and I modified the persistence.xml but I did not manage to make it work on mysql server. What I need to know is exactly what file(s) I should change and exactly how that file(s) should be changed, so that the registration example will work with mysql.


      Many thanks in advance,
      Marc

        • 1. Re: HSQL to MYSQL
          cosmo

          Hello,



          1. Make sure you have the MySQL Driver located in your {app-server}/server/default/lib

          2. Also make sure your database exists in MySQL

          3. Change dialect within persistence.xml

          4. Modify datasource -ds.xml at {app-server}/server/default/deploy





          • 2. Re: HSQL to MYSQL
            standup

            Many thanks,


            The problems was with the jdbc connector driver. I copy it in the server/default/lib folder, and now it works.


            Thanks again Aldo.

            • 3. Re: HSQL to MYSQL
              standup

              Hello Aldo,


              Thank you four your answers. I followed the steps you described and I managed to put the registration example to work with myql.


              marc.

              • 4. Re: HSQL to MYSQL
                oneclic.mohsen_med2003.yahoo.fr

                hi,
                i'm newbie in seam and i have to do some works in my studies with Jboss seam. Please can you send me any docs wich can help me to transform the database of default seam examples from hsql to Mysql.
                What could i modify, and how could i create the database.