Sun Java System JDBC Driver for Oracle 9i and 10g Databases

The JAR files for this driver are smbase.jar, smoracle.jar, and smutil.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: com.sun.sql.jdbcx.oracle.OracleDataSource

• Properties:

  • serverName - Specify the host name or IP address of the database server.

  • portNumber - Specify the port number of the database server.

  • SID - Set as appropriate.

  • user - Set as appropriate.

  • password - Set as appropriate.

• URL: jdbc:sun:oracle://serverName[:portNumber][;SID=databaseName]