IBM DB2 8.1Type 2 Driver
TheJAR les for the DB2 driver are db2jcc.jar,db2jcc_license_cu.jar, and db2java.zip.
Setenvironment 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
Congurethe connection pool using the following settings:
Name:Use this name when you congure the JDBC resource later.
ResourceType: Specify the appropriate value.
DatabaseVendor: DB2
DataSourceClassname: 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.
JConnectType 4 Driver for Sybase ASE 12.5 Databases
TheJAR le for the Sybase driver is jconn2.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: Sybase
DataSourceClassname: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.
CongurationsforSpecic JDBC Drivers
SunGlassFishEnterprise Ser ver2.1 Administration Guide • December 200856