<local-tx-datasource>
|      <jndi-name>nrg2Datasource</jndi-name>
|      <connection-url>jdbc:mysql://localhost:3306/db</connection-url>
|      <driver-class>com.mysql.jdbc.Driver</driver-class>
|      <user-name>db</user-name>
|      <password>pass</password>
|      <exception-sorter-class-name>
|         org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
|      </exception-sorter-class-name>
|    <metadata>
|         <type-mapping>mySQL</type-mapping>
|      </metadata>
|      <valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name>
|      <check-valid-connection-sql>SELECT count(warehouseId) FROM warehouse</check-valid-connection-sql>
|      <new-connection-sql>SELECT count(warehouseId) FROM warehouse</new-connection-sql>
|   </local-tx-datasource>

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4073108#4073108

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4073108
_______________________________________________
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user