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