1 Reply Latest reply on Jun 24, 2004 7:03 PM by Rafal Kedziorski

    More than one DB configuration

    Rafal Kedziorski Novice

      Hi,

      I wan't to define more than one MySQL definition. How do this?

      This is my current configuration:


      <local-tx-datasource>
      <jndi-name>MmcmsDS</jndi-name>
      <connection-url>jdbc:mysql://10.0.0.10:3306/xxx</connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>xxx</user-name>
      xxx
      <connection-property name="autoReconnect">true</connection-property>

      <!--pooling parameters-->
      <min-pool-size>5</min-pool-size>
      <max-pool-size>50</max-pool-size>
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      </local-tx-datasource>


      Stored in mysql-ds.xml


      Regards,
      Rafal