■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.
MySQLType 4 Driver
TheJAR le for the MySQL driver is mysql-connector-java-version-bin-g.jar, for example,
mysql-connector-java-5.0.5-bin-g.jar.Congure the connection pool using the following
settings:
■Name:Use this name when you congure the JDBC resource later.
■ResourceType: Specify the appropriate value.
■DatabaseVendor: mysql
■DataSourceClassname: 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 OraxoJDBC Driver for Oracle 8.1.7 and 9.x
Databases
TheJAR le for the Inet Oracle driver is Oranxo.jar. Congure the connection pool using the
followingsettings:
■Name:Use this name when you congure the JDBC resource later.
■ResourceType: Specify the appropriate value.
■DatabaseVendor: Oracle
CongurationsforSpecic JDBC Drivers
Chapter3 • JDBC Resources 57