Importing the JDBC library settings

You can use the JDBC library settings file to set up the JDBC driver information.

About this task

QMF administrators are responsible for distributing the JDBC driver information that you will need in order to access any data source. In most cases, administrators distribute this information by deploying a preconfigured JDBC library settings file when the application interface that you are using is installed.

Another method administrators can use to distribute this information is to create the JDBC library settings file and make it available to all users who will then import the file using their version of the application interface.

To import the JDBC library settings file:

Procedure

  1. Select File > Import > Connection and JDBC library settings. The Import Connection and JDBC Library Settings window opens.
  2. Specify where to find the settings.xml/settings.zip settings file in the Settings file field. You can use Browse to locate the file.
  3. Make sure that the JDBC library settings check box is selected and the Repository connections check box is not selected.
    Note: If the settings.zip archive includes the JAR driver files, and you want to import them as well, you must select the Driver files check box. Otherwise, make sure it is not selected.
  4. Specify how you want conflicts with previous JDBC library settings to be resolved using Conflict resolving . Select Override existing settings to replace all conflicting information with new information. Select Keep existing settings to not update any existing information with new information. Select Manually resolve conflicts to open the Conflicts window where you will manually resolve conflicts between existing and new JDBC library settings.
  5. Click Finish. The Import Connections and JDBC Library Settings window closes. The JDBC library information is saved. You can display your JDBC library information by selecting Preferences from the View menu and then select JDBC Libraries.