3 Replies Latest reply on Nov 28, 2002 7:23 AM by Kristof Van Cleemput

    use mysql in jboss 3.0.2

    meixiaolong Newbie

      hello,everyone,
      My server is jboss3.0.2,
      I have copied mysql-sevice.xml to jboss3.0.2/server/default/deploy directory,and mysql worked in jboss 3.0.2,but I found that I only configured one database connection according to mysql-service.xml file,if I want to configure multi- database connection ,how do I do now?
      thank you advance!

        • 1. Re: use mysql in jboss 3.0.2
          Kristof Van Cleemput Newbie

          Make another service file with an other database name.

          Regards

          Kristof

          • 2. Re: use mysql in jboss 3.0.2
            meixiaolong Newbie

            thanks,and I have two database in mysql server,I want to configure two connection in mysql-service.xml file,can you tell me what do I do next?

            • 3. Re: use mysql in jboss 3.0.2
              Kristof Van Cleemput Newbie

              you have a mysql service1 and mysqlservice2 (for instance)

              in the first there is something like

              dbase1


              <config-property name="ConnectionURL" type="java.lang.String">jdbc connection URL </config-property>
              <config-property name="DriverClass" type="java.lang.String">jdbcdriver</config-property>
              <!--set these only if you want only default logins, not through JAAS -->
              <config-property name="UserName" type="java.lang.String">user</config-property>
              <config-property name="Password" type="java.lang.String">password</config-property>


              and in the second you change dbase1 with dbase2
              and the connection URL to the one for the second db

              In your code you have to use dbase1 or dbase2 for getting the connection.

              Check the manual for more info.

              Regards

              Kristof