Sun Microsystems 820433510 manual Sun GlassFish Jdbc Driver for DB2 Databases

Configurations for Specific JDBC Drivers

Sun GlassFish JDBC Driver for DB2 Databases

The JAR files for this driver aresmbase.jar, smdb2.jar, and smutil.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: DB2

■DataSource Classname: com.sun.sql.jdbcx.db2.DB2DataSource

■Properties:

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

■portNumber - Specify the port number of the database server.

■databaseName - Set as appropriate.

■user - Set as appropriate.

■password - Set as appropriate.

■URL: jdbc:sun:db2://serverName:portNumber;databaseName=databaseName

Sun GlassFish JDBC Driver for Oracle 8.1.7 and 9.x Databases

The JAR files for this driver aresmbase.jar, smoracle.jar, and smutil.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

■DataSource Classname: com.sun.sql.jdbcx.oracle.OracleDataSource

■Properties:

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

■portNumber - Specify the port number of the database server.

■SID - Set as appropriate.

■user - Set as appropriate.

■password - Set as appropriate.

■URL: jdbc:sun:oracle://serverName[:portNumber][;SID=databaseName]

54 Sun GlassFish Enterprise Server 2.1 Administration Guide • December 2008