2 Replies Latest reply on Jun 12, 2006 7:54 AM by VisolveGroup

    Dukes Bank application deployment in jboss using MySql

    Vikram B Newbie

      HI
      i deployed Dukes Bankapplication(j2ee1.4 tutorial) using HsqlDB succesfully
      , but i tried to deploy the same thing using mysql iam getting problems. can anybody have the documentation reg this.Please do the needful

      Regards
      Vikram

        • 1. Re: Dukes Bank application deployment in jboss using MySql
          VisolveGroup Novice

          Hi,

          You can use the following steps to make the Dukes bank application work with MySQL.

          1. Copy the mysql-ds.xml file from docs/examples/jca to server/default/deploly. The default datasource name is MySqlDS, make a note of it. Modify the connection-url (with the hostname and dbname), user-name and password as per your environment.

          11 <connection-url>jdbc:mysql://mysql-hostname:3306/jbossdb</connection-url>
          12 <driver-class>com.mysql.jdbc.Driver</driver-class>
          13 <user-name>x</user-name>
          14 password y


          2. Modify the datasource name in the {dukes-home}/examples/bank/dd/ebb/boss from DefaultDS to MySqlDS. If you are using UNIX, you can use following commands to do this job.

          # sed 's/DefaultDS/MySqlDS/g' dd/ejb/jboss.xml > temp.xml
          # mv temp.xml dd/ejb/jboss.xml

          3. You have to insert the data's manually into the mysql. For this you can use the following commands.

          # mysql --database=jbossdb < hsql-create-table.sql
          # mysql --database=jbossdb < insert.sql

          Note that, jbossdb is database we have used. Change the database name accordingly.

          Regards,
          ViSolve JBoss Team

          • 2. Re: Dukes Bank application deployment in jboss using MySql
            VisolveGroup Novice

            Hello,

            Also,

            1. Copy the mysql jdbc connector jar file into the server/default/lib directory.

            2. Grant the access permission to database with the following command.

            mysql> grant all on database_name.* to user_name@'localhost' identified by 'passwd'

            Regards,
            ViSolve JBoss Team.