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:
Applies to Java administrative console of Advanced Edition Version 4.0
Applies to Web administrative console of Advanced Single Server Edition Version 4.0
Applies to Application Client Resource Configuration Tool
-
Classpath
or Server Class Path
- 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
- Name-value pairs for setting additional properties
-
Description
- A description of the driver, for your administrative records
-
Implementation Class
or Implementation Classname
- 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)
InstantDB (NOT supported as an administrative database)
- com.ibm.ejs.cm.portability.IDBConnectionPoolDataSource (one phase commit protocol)
-
Name
- 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
- 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
- See the resource provider properties (only valid if you are
using Advanced Single Server Edition).
-
Server Class Path
- See Classpath
-
URL prefix
- 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
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:
- Complimentary copies with WebSphere Application Server:
|
HP-UX |
- DB2: $DB2_HOME/java12/db2java.zip or $DB2_HOME/java/db2java.zip
- Oracle: $ORACLE_HOME/jdbc/lib/classes12.zip
-
Merant SequelLink:
- Complimentary copies with WebSphere Application Server:
|
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:
- 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.
- 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.
- Read and then accept the license terms.
- 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:
- 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.
- 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.
- Read and then accept the license terms.
- 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:
- Complimentary copies with WebSphere Application Server:
|
Windows |
- DB2: C:\SQLLIB\java\db2java.zip
- Oracle: C:\Oracle\Ora81\jdbc\lib\classes12.zip
-
Merant SequelLink:
- Complimentary copies with WebSphere Application Server:
|
|
|