Installing a JDBC driver on WebSphere Application Server Community Edition

InfoSphere Optim web applications can connect to an Optim directory only if the application server has a Java Database Connectivity (JDBC) driver for the Optim directory database. JDBC drivers for supported versions of the IBM DB2 database are already installed. Use this task to install JDBC drivers for other vendors on the English version of WebSphere® Application Server Community Edition.

The version of WebSphere Application Server Community Edition that is delivered with InfoSphere Optim web applications is available only in English. You must configure this version of WebSphere Application Server Community Edition by using an English user interface. However, when you use the connection manager or the manager, the language setting of the browser determines the language of the user interface.

Use the Administrative Console of WebSphere Application Server Community Edition to install a JDBC driver. The default location of the Administrative Console is http://hostname:8080/console, where hostname is the host name of the computer on which WebSphere Application Server Community Edition is installed.

When you install a JDBC driver, you must identify the driver to the application server by specifying the following information:
  • Group: the vendor identifier (oracle, sql, or com.ibm.db2)
  • Artifact: the name of the JDBC driver file without the .jar extension
  • Version: the version number of the driver
  • Type: jar

To install a JDBC driver on WebSphere Application Server Community Edition:

  1. Under Services, click Repository.
  2. Review the current repository entries to ensure that the JDBC driver is not already installed. The entry for a JDBC driver is of the form group/artifact/version/jar. For example, the JDBC driver for DB2 v9.5 is com.ibm.db2/db2jcc/9.5/jar.
  3. Click Browse and browse to select the JDBC driver.
  4. Enter the group, artifact, version, and type for the JDBC driver and click Install.
  5. Review the current repository entries again to ensure that the JDBC driver was installed.


Feedback