Configurations for Specific JDBC Drivers

■password - Set as appropriate.

Inet Sybelux JDBC Driver for Sybase Databases

The JAR file for the Inet Sybase driver isSybelux.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: com.inet.syb.SybDataSource

■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.

■password - Set as appropriate.

■databaseName - Set as appropriate. Do not specify the complete URL, only the database name.

Oracle Thin Type 4 Driver for Oracle 8.1.7 and 9.x Databases

The JAR file for the Oracle driver isojdbc14.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:Specify one of the following:

oracle.jdbc.pool.OracleDataSource

oracle.jdbc.xa.client.OracleXADataSource

■Properties:

■user - Set as appropriate.

■password - Set as appropriate.

■URL - Specify the complete database URL using the following syntax:

jdbc:oracle:thin:[user/password]@host[:port]/service

Chapter 3 • JDBC Resources

59

Page 59
Image 59
Sun Microsystems 820433510 Inet Sybelux Jdbc Driver for Sybase Databases, DataSource Classname com.inet.syb.SybDataSource