JBoss Community

MySQL 5.1 with JBoss ESB 5.0.0

reply from Sathya Prakash in Beginner's Corner - View the full discussion

Hi ,

I have created mysql Datasoucre.xml and copied to deploy folder and hsql datasoucre.xml.

<datasources>
<local-tx-datasource>
    <jndi-name>DefaultJNDI</jndi-name>
    <connection-url>jdbc:mysql://10.10.10.10:3306;DatabaseName=spc</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>tp_user</user-name>
    <password>tp_user</password>
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <min-pool-size>1</min-pool-size>
    <max-pool-size>20</max-pool-size>
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
</local-tx-datasource>
</datasources>

Is there any more to do changes?

Reply to this message by going to Community

Start a new discussion in Beginner's Corner at Community