Libraries include configuration information for a full range of JDBC drivers. Repertoire 9 enables you to configure JDBC drivers more easily. Any JDBC drivers that require native components will usually require the Ambience system to be stopped and restarted. Currently, most drivers are JDBC-Net pure Java drivers or native protocol pure Java drivers. If there is no native code, then you can transfer the JAR files to the job engine machines by putting them in /Public/lib in the Repository Tree and clicking the Refresh Job Engine Jars... button. This will cause the job engines to stop at the end of their current task. The Process Managers will then start them up again, with the updated classpath (including any new JDBC drivers).

Figure 1.2. Libraries


Configuring JDBC Drivers

To illustrate the JDBC driver configuration procedure, here are the steps:

  1. Click the Administration Tools... button on the workspace toolbar. Click the Libraries tab. The JDBC drivers display.

  2. Find and select the desired driver from the list. Click the Edit button. The JDBC Driver dialog displays. Fill in the host machine name to replace <host> in the URL field. Leave the class information as it is.

  3. Select the Enabled checkbox and click OK.

  4. If there is no native code for the driver, download the driver’s JAR file from the vendor's Web site. Copy the driver's JAR file into the /Public/lib folder in the Repository Tree. Click the Refresh Job Engine Jars... button. A message may pop up, as shown in Figure 1.3, “Refresh Job Engine Jars”:

    Figure 1.3. Refresh Job Engine Jars

    Refresh Job Engine Jars