B.6. MySQL Datasource
B.6.1. Installing the Driver
Procedure B.1. Installing the Driver
- Download the driver from http://www.mysql.com/products/connector/j/. Make sure to choose the driver based on your version of MySQL.
- Expand the driver ZIP or TAR file, and locate the
.jar
file. - Move the
.jar
file into<JBOSS_HOME>/server/<PROFILE>/lib
. - Copy the
<JBOSS_HOME>docs/examples/jca/mysql-ds.xml
example datasource deployer file to<JBOSS_HOME>/server/<PROFILE>/deploy/
, for use as a template.
MySQL limitations
- Millisecond and microsecond measurements
- MySQL does not currently support millisecond and microsecond measurements when returning database values such as
TIME
andTIMESTAMP
. Tests which rely on these measurements will fail.