InfoCenter Home >
6: Administer applications >
6.6: Tools and resources quick reference >
6.6.14: Administering database connections (overview) >
6.6.14.0: Properties of JDBC and data source providers

6.6.14.0: Properties of JDBC and data source providers

The administrative tools use the following terms for the same type of configuration:
JDBC provider or data source provider

Key:
Property name in the Java-based administrative console Applies to Java administrative console of Advanced Edition Version 4.0
Property name in the Web-based administrative console Applies to Web administrative console of Advanced Single Server Edition Version 4.0
Property name in the application client resource configuration tool Applies to Application Client Resource Configuration Tool

Classpath  Property name in the Java-based administrative console  Property name in the application client resource configuration tool or Server Class Path  Property name in the Web-based administrative console
The path to the JAR file containing the implementation code for the database driver, such as db2java.zip file for DB2.

See the reference below for a list of default locations.

Custom Properties  Property name in the application client resource configuration tool
Name-value pairs for setting additional properties
Description  Property name in the Java-based administrative console  Property name in the Web-based administrative console  Property name in the application client resource configuration tool
A description of the driver, for your administrative records

Implementation Class  Property name in the Java-based administrative console  Property name in the application client resource configuration tool or Implementation Classname  Property name in the Web-based administrative console
The name of the Java data source class provided by the database vendor.

DB2:

  • COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource (one phase commit protocol)
  • COM.ibm.db2.jdbc.DB2XADataSource (two phase commit protocol)

DB2 on iSeries - toolbox driver

  • com.ibm.as400.access.AS400JDBCConnectionPoolDataSource (one phase commit protocol)
  • com.ibm.as400.access.AS400JDBCXADataSource (two phase commit protocol)

DB2 on iSeries - native driver

  • com.ibm.db2.jdbc.app.DB2StdConnectionPoolDataSource (one phase commit protocol)
  • com.ibm.db2.jdbc.app.DB2StdXADataSource (two phase commit protocol)

Oracle:

  • oracle.jdbc.pool.OracleConnectionPoolDataSource (one phase commit protocol)
  • oracle.jdbc.xa.client.OracleXADataSource (two phase commit protocol)

Sybase:

  • com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource (one phase commit protocol)
  • com.sybase.jdbc2.jdbc.SybXADataSource (two phase commit protocol)

Merant:

  • com.merant.sequelink.jdbcx.datasource.SequeLinkDataSource (one and two phase commit protocol)

Informix

  • com.informix.jdbcx.IfxConnection PoolDataSource (one phase commit protocol)
  • com.informix.jdbcx.IfxXADataSource (two phase commit protocol)

Name  Property name in the Java-based administrative console  Property name in the Web-based administrative console  Property name in the application client resource configuration tool
A name for the driver. It is recommended you enter a name that is suggestive of the database product you are using, such as DB2JdbcDriver.
Node  Property name in the Java-based administrative console  Property name in the Web-based administrative console
The node (machine) on which to install the driver.

For Advanced Edition: Use the buttons on the Nodes panel to access dialogs for installing drivers on specific nodes and for uninstalling drivers.

Property Set  Property name in the Web-based administrative console
See the resource provider properties (only valid if you are using Advanced Single Server Edition).

Server Class Path  Property name in the Web-based administrative console
See Classpath
URL prefix  Property name in the application client resource configuration tool
The URL prefix with which this driver is associated. The URL prefix is comprised of the protocol and subprotocol, separated by a colon (":").

The Database Name of the data source is appended to the URL prefix to produce the full JDBC URL of the database, such as jdbc:db2:was

Locating JDBC providers on your operating system

The following table lists the default locations of JDBC provider files. See the product prerequisites Web site for the most up-to-date information on the operating system brands and databases supported by IBM WebSphere Application Server. Column 1 in the table lists the operating system, and column 2 shows a list of the drivers that are available for use with each database supported for the operating system.

Operating system Drivers
AIX
  • DB2: $DB2_HOME/java12/db2java.zip or $DB2_HOME/java/db2java.zip
  • Oracle: $ORACLE_HOME/jdbc/lib/classes12.zip
  • Sybase: sybase_install_root/jConnect-5_2/classes/jconn2.jar
  • Merant SequelLink:
HP-UX
  • DB2: $DB2_HOME/java12/db2java.zip or $DB2_HOME/java/db2java.zip
  • Oracle: $ORACLE_HOME/jdbc/lib/classes12.zip
  • Merant SequelLink:
Linux (Intel)
  • DB2: $DB2_HOME/java12/db2java.zip or $DB2_HOME/java/db2java.zip
  • Oracle: $ORACLE_HOME/jdbc/lib/classes12.zip
    Note: Oracle 8i lacks the JDBC 2.0 driver classes12.zip.
    The Oracle 8i distribution does not provide the JDBC 2.0 driver classes12.zip for Linux platforms. As a workaround, download the Solaris classes12.zip file from the Oracle Web site:
    1. Go to
      http://otn.oracle.com/software/tech/java/sglj_jdbc/content.html
      You may need to register on the Oracle Web site before you can download from it.
    2. Under Oracle JDBC Drivers and Download the drivers Solaris, click the link Oracle8i 8.1.7.1 (Patch) JDBC Drivers for use with IBM Software Development Kit 1.2.x for Solaris.
    3. Read and then accept the license terms.
    4. Under Oracle8i 8.1.7.1 JDBC Drivers for use with IBM Software Development Kit 1.2.x, click the link JDBC-Thin, 100% Java and download the driver file.
    You can use the Java thin driver only. Any attempts to use the OCI (thick) driver result in errors. For more information about the problem, contact Oracle Technical Support.
Linux on S/390
  • Oracle: $ORACLE_HOME/jdbc/lib/classes12.zip
    Note: Oracle 8i lacks the JDBC 2.0 driver classes12.zip.
    The Oracle 8i distribution does not provide the JDBC 2.0 driver classes12.zip for Linux platforms. As a workaround, download the Solaris classes12.zip file from the Oracle Web site:
    1. Go to
      http://otn.oracle.com/software/tech/java/sglj_jdbc/content.html
      You may need to register on the Oracle Web site before you can download from it.
    2. Under Oracle JDBC Drivers and Download the drivers Solaris, click the link Oracle8i 8.1.7.1 (Patch) JDBC Drivers for use with IBM Software Development Kit 1.2.x for Solaris.
    3. Read and then accept the license terms.
    4. Under Oracle8i 8.1.7.1 JDBC Drivers for use with IBM Software Development Kit 1.2.x, click the link JDBC-Thin, 100% Java and download the driver file.
    You can use the Java thin driver only. Any attempts to use the OCI (thick) driver result in errors. For more information about the problem, contact Oracle Technical Support.
Solaris
  • DB2: $DB2_HOME/java12/db2java.zip or $DB2_HOME/java/db2java.zip
  • Oracle: $ORACLE_HOME/jdbc/lib/classes12.zip
  • Sybase: sybase_install_root/jConnect-5_2/classes/jconn2.jar
  • Merant SequelLink:
Windows
Go to previous article: Administering database connections (overview) Go to next article: Properties of data sources

 

 
Go to previous article: Administering database connections (overview) Go to next article: Properties of data sources