beautypg.com

Sun glassfish jdbc driver for db2 databases – Sun Microsystems GLASSFISH ENTERPRISE 820433510 User Manual

Page 54

background image

Sun GlassFish JDBC Driver for DB2 Databases

The JAR files for this driver are smbase.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 are smbase.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]

Configurations for Specific JDBC Drivers

Sun GlassFish Enterprise Server 2.1 Administration Guide • December 2008

54