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 |