4 Replies Latest reply on May 6, 2003 10:58 PM by natonoll

    mysql on Jboss 3.2

    sysuser1

      Does anyone have a step by step list of configuring Jboss 3.2 to run on mysql or configuring Jboss to run on other DBs besides the default?

      Thanks.

        • 1. Re: mysql on Jboss 3.2
          hasanali00

          read "JBoss3.2.0 & mySQl solution " under 'datasource configuration' forum

          • 2. Re: mysql on Jboss 3.2
            fbiaggi

            Ciao,
            this is my config and works without problems:

            mysql-ds.xml

            <?xml version="1.0" encoding="UTF-8"?>

            <!-- ===================================================================== -->
            <!-- -->
            <!-- JBoss Server Configuration -->
            <!-- -->
            <!-- ===================================================================== -->

            <!-- $Id: mysql-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->
            <!-- ==================================================================== -->
            <!-- Datasource config for MySQL using 2.0.11 driver -->
            <!-- ==================================================================== -->



            <local-tx-datasource>
            <jndi-name>sisaejb</jndi-name>
            <connection-url>jdbc:mysql://127.0.0.1:3306/mydb?autoReconnect=true&amp;useUnicode=true</connection-url>
            <!-- <driver-class>com.mysql.jdbc.Driver</driver-class> -->
            <driver-class>com.p6spy.engine.spy.P6SpyDriver</driver-class>
            <user-name>root</user-name>

            </local-tx-datasource>


            • 3. Re: mysql on Jboss 3.2
              sysuser1

              Thanks.

              • 4. Re: mysql on Jboss 3.2
                natonoll

                That has worked well for me but I've been going around in circles wondering if that is enough?

                Don't I need a connection pool for my MySQL data source. The JCA docs say to use the datasource example which I have but when I look at the Connection Factories they are all using DefaultDS still.

                When I look at the Hypersonic datasource it has pooling setting, like I'd expect.

                Do I need a connection pool or is my weblogic experience blinding my judgement?

                Thanks,