Sun Microsystems 820433510 MySQL Type 4 Driver, Com.mysql.jdbc.jdbc2.optional.MysqlDataSource

Configurations for Specific JDBC Drivers

■password - Set as appropriate.

■databaseName - Set as appropriate. Do not specify the complete URL, only the database name.

■BE_AS_JDBC_COMPLIANT_AS_POSSIBLE - Set to true.

■FAKE_METADATA - Set to true.

MySQL Type 4 Driver

The JAR file for the MySQL driver ismysql-connector-java-version-bin-g.jar, for example, mysql-connector-java-5.0.5-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.

jdbc:mysql://host:port/database

Inet Oraxo JDBC Driver for Oracle 8.1.7 and 9.x Databases

The JAR file for the Inet Oracle driver isOranxo.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: Oracle

Chapter 3 • JDBC Resources 57