MySQL Server Database Type 4 Sun GlassFish/DataDirect JDBC Driver

The Sun MySQL driver only works with MySQL Enterprise. The JAR file for the Sun driver is smmysql.jar; the JAR file for the DataDirect driver is mysql.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 Server

• DataSource Classname: com.sun.sql.jdbcx.mysql.MySQLDataSource

  DataDirect DataSource: com.ddtek.jdbcx.mysql.MySQLDataSource

• Properties:

  • serverName – Specify the host name or IP address and the port of the database server.

  • portNumber – Specify the port number of the database server.

  • user – Set as appropriate.

  • password – Set as appropriate.

  • selectMethod – Set to cursor.