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 drivers: WebSphere Application Server

6.6.14.0: Properties of JDBC drivers: WebSphere Application Server

Description
A description of the driver, for your administrative records.

Driver Implementation Class, Implementation Class
Specifies the name of the Java class that implements the driver.

Jar file, Classpath
Specifies the path to the JAR file containing the implmentation code for the database driver, such as db2java.zip file for DB2.

See the reference below for a list of default locations.

JTA Enabled
Specifies whether the driver can handle Java-based two-phase commit transactions. JTA is a transaction API for Java applications.

If not performing distributed transactions, set this value to False.

Note that for Application Server Version 3.0x, the URL Prefix setting had to contain "jta," in addition to selecting JTA Enabled. For Version 3.5, selecting JTA Enabled is sufficient. The URL Prefix value is independent of whether JTA is enabled.

Name
Specifies 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
Specifies the node (machine) on which to install the driver.

URL prefix
Specifies 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
  • InstantDB: product_installation_root/lib/idb.jar
  • Introduced in Version 3.5.3   Merant SequelLink:
HP-UX
Linux (Intel)
  • DB2: $DB2_HOME/java12/db2java.zip or $DB2_HOME/java/db2java.zip
  • Oracle: $ORACLE_HOME/jdbc/lib/classes12.zip
  • InstantDB: product_installation_root/lib/idb.jar
Linux on S/390
NetWare
  • DB2: $DB2_HOME/lib/db2java.zip
  • Oracle: $ORACLE_HOME/jdbc/lib/classes12.zip
  • InstantDB: product_installation_root/lib/idb.jar
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
  • InstantDB: product_installation_root/lib/idb.jar
  • Introduced in Version 3.5.3   Merant SequelLink:
Windows
  • DB2: C:\SQLLIB\java\db2java.zip
  • Oracle: C:\Oracle\Ora81\jdbc\lib\classes12.zip
  • InstantDB: product_installation_root/lib/idb.jar
  • Introduced in Version 3.5.3   Merant SequelLink:
    • Complimentary copies with WebSphere Application Server:
    • Note that the same data source implementation class is used for both non JTA and JTA enabled datasources. Also, this class is found in the sljcx.jar, not the sljc.jar.

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