test

Oracle iPlanet Web Server 7.0.9 Administrator's Guide

JDBC Drivers Known to Work With Web Server

The following table provides a list of common JDBC drivers and their properties. These drivers need to be configured while adding a new JDBC resource. See Adding a new JDBC Resource.

Table 11–2 List of common and JDBC drivers

Driver

Class Name

Properties

Oracle driver

oracle.jdbc.pool.OracleDataSource

  • url

  • user

  • password

Sun JDBC driver for Oracle

com.sun.sql.jdbcx.oracle.OracleDataSource

  • serverName

  • portNumber

  • user

  • password

  • SID

DB2 IBM driver

com.ibm.db2.jdbc.DB2DataSource

  • serverName

  • databaseName

  • portNumber

  • user

  • password

  • driverType

Sun JDBC driver for DB2

com.sun.sql.jdbcx.db2.DB2DataSource

  • databaseName

  • locationName

  • packageName

  • password

  • portNumber

  • serverName

  • user

MS SQLServer driver

com.ddtek.jdbcx.sqlserver.SQLServerDataSource

  • databaseName

  • password

  • user

  • serverName

  • portNumber

Sun JDBC driver for MS

com.sun.sql.jdbcx.sqlserver.SQLServerDataSource

  • databaseName

  • password

  • user

  • serverName

  • portNumber

Sybase driver

com.sybase.jdbcx.SybDataSource

  • databaseName

  • password

  • portNumber

  • serverName

  • user

Sun JDBC driver for Sybase

com.sun.sql.jdbcx.sybase.SybaseDataSource

  • databaseName

  • password

  • user

  • portNumber

  • serverName

MySQL driver

com.mysql.jdbc.jdbc2.optional.MysqlDataSource

  • serverName

  • port

  • databaseName

  • user

  • password

Informix driver

com.informix.jdbcx.IfxDataSource

  • portNumber

  • databaseName

  • IfxIFXHOST (The IP address or the host name of the computer running the Informix database)

  • serverName

  • user

  • password

Sun JDBC driver for Informix

com.sun.sql.jdbcx.informix.InformixDataSource

  • databaseName

  • informixServer ( The name of the Informix database server to which you want to connect)

  • password

  • portNumber

  • severName

PostgreSQL driver

org.postgresql.ds.PGSimpleDataSource

  • serverName

  • databaseName

  • portNumber

  • user

  • password

Apache Derby driver

org.apache.derby.jdbc.EmbeddedDataSource

  • databaseName

  • user

  • password

Note –

In the previously mentioned list, all of the Sun drivers are shipped with Web Server. For other drivers, check with the driver vendor documentation for the latest versions of these drivers and the class names. The information provided in the previously mentioned list may not be the latest driver information.