MM MySQL Type 4 Driver (Non-XA)

The JAR file for the MySQL driver is mysql-connector-java-version-bin-g.jar, for example, mysql-connector-java-3.1.12-bin-g.jar. Configure the connection pool using the following settings:

• Name: Use this name when you configure the JDBC resource later.

• Resource Type: Specify the appropriate value.

• Database Vendor: mysql

• DataSource Classname: Specify one of the following:

  com.mysql.jdbc.jdbc2.optional.MysqlDataSource

• Properties:

  • serverName - Specify the host name or IP address of the database server.

  • port - Specify the port number of the database server.

  • user - Set as appropriate.

  • password - Set as appropriate.

  • databaseName - Set as appropriate.

  • URL - If you are using global transactions, you can set this property instead of serverName, port, and databaseName.

    The MM MySQL Type 4 driver doesn’t provide a method to set the required relaxAutoCommit property, so you must set it indirectly by setting the URL property:

    jdbc:mysql://host:port/database?relaxAutoCommit="true"