Sun Microsystems GLASSFISH ENTERPRISE 820433510 - Manual (Page 56)

IBM DB2 8.1 Type 2 Driver
The JAR files for the DB2 driver are db2jcc.jar, db2jcc_license_cu.jar, and db2java.zip.
Set environment variables as follows:
LD_LIBRARY_PATH=/usr/db2user/sqllib/lib:${Java EE.home}/lib
DB2DIR=/opt/IBM/db2/V8.1
DB2INSTANCE=db2user
INSTHOME=/usr/db2user
VWSPATH=/usr/db2user/sqllib
THREADS_FLAG=native
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.ibm.db2.jcc.DB2SimpleDataSource
■ Properties:
■ user - Set as appropriate.
■ password - Set as appropriate.
■ databaseName - Set as appropriate.
■ driverType - Set to 2.
■ deferPrepares - Set to false.
JConnect Type 4 Driver for Sybase ASE 12.5 Databases
The JAR file for the Sybase driver is jconn2.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: Sybase
■ DataSource Classname: Specify one of the following:
com.sybase.jdbc2.jdbc.SybDataSource
com.sybase.jdbc2.jdbc.SybXADataSource
■ Properties:
■ serverName - Specify the host name or IP address of the database server.
■ portNumber - Specify the port number of the database server.
■ user - Set as appropriate.
Configurations for Specific JDBC Drivers
Sun GlassFish Enterprise Server 2.1 Administration Guide • December 2008 56