Here an example, which I usually place directly into the $jboss/server/$instance/deploy/ directory:
<datasources> | <local-tx-datasource> | <jndi-name>TestDS</jndi-name> | <connection-url>jdbc:mysql://localhost:3306/test</connection-url> | <driver-class>com.mysql.jdbc.Driver</driver-class> | <user-name>test.dba</user-name> | <password>test</password> | <connection-property name="useCompression">false</connection-property> | <connection-property name="logSlowQueries">true</connection-property> | <connection-property name="zeroDateTimeBehavior" | >convertToNull</connection-property> | <!-- | <connection-property name="characterEncoding" | >utf8</connection-property> | <connection-property name="useUnicode">true</connection-property> | <connection-property name="connectionCollation">utf8_general_ci</connection-property> | --> | <exception-sorter-class-name | >com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name> | <valid-connection-checker-class-name | >com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name> | <metadata> | <type-mapping>mySQL</type-mapping> | </metadata> | </local-tx-datasource> | </datasources> | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3944547#3944547 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3944547 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
