test

Sun Java System Web Server 7.0 Update 8 Administrator's Guide

JDBC Drivers Known to Work With the Sun Java System 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 Java System 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 Java System 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 Java System 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 Java System 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 Java System 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 Java System JDBC drivers are shipped with the 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.