22.3.12. Using Connector/J with JBoss

These instructions cover JBoss-4.x. To make the JDBC driver classes available to the application server, copy the .jar file that comes with Connector/J to the lib directory for your server configuration (which is usually called default). Then, in the same configuration directory, in the subdirectory named deploy, create a datasource configuration file that ends with -ds.xml, which tells JBoss to deploy this file as a JDBC Datasource. The file should have the following contents:

<datasources>    <local-tx-datasource>        <jndi-name>MySQLDB</jndi-name>        <connection-url>jdbc:mysql://localhost:3306/dbname</connection-url>        <driver-class>com.mysql.jdbc.Driver</driver-class>        <user-name>user</user-name>        <password>pass</password>        <min-pool-size>5</min-pool-size>        <max-pool-size>20</max-pool-size>        <idle-timeout-minutes>5</idle-timeout-minutes>        <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>    </local-tx-datasource></datasources>