A.6. MySQL Datasource

A.6.1. Installing the Driver

Procedure A.1. Installing the Driver

  1. Download the driver from http://www.mysql.com/products/connector/j/. Make sure to choose the driver based on your version of MySQL.
  2. Expand the driver ZIP or TAR file, and locate the .jar file.
  3. Move the .jar file into $JBOSS_HOME/server/config_name/lib.
  4. Copy the $JBOSS_HOMEdocs/examples/jca/mysql-ds.xml example datasource deployer file to $JBOSS_HOME/server/config_name/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 and TIMESTAMP. Tests which rely on these measurements will fail.