Mysql type 4 driver – Sun Microsystems GLASSFISH ENTERPRISE 820433510 User Manual
Page 57
■
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 is mysql-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 is Oranxo.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
Configurations for Specific JDBC Drivers
Chapter 3 • JDBC Resources
57