Update the JDBC Driver Support

This topic describes how to configure the Gateway to work with JDBC (Java Database Connectivity).
gateway90
This topic describes how to configure the Gateway to work with JDBC (Java Database Connectivity).
To update the JDBC Driver support, perform the following tasks:
Install the JDBC Client Libraries
To install the client libraries:
  1. Using SCP or SFTP, copy the appropriate client libraries to the Gateway as the
    ssgconfig
    user.
  2. Log in to the Gateway appliance as the
    root
    user.
  3. Change the permissions of the client libraries with the following command:
    # chmod 444 /home/ssgconfig/*.jar
  4. Change the ownership of the client libraries with the following command:
    # chown layer7.layer7 /home/ssgconfig/*.jar
  5. Move the client libraries from:
    /home/ssgconfig
    to:
    /opt/SecureSpan/Gateway/runtime/lib/ext
You can now update the list of supported JDBC Driver classes.
Update the List of Supported JDBC Driver Classes
Use the
com.l7tech.server.jdbcDriver
system property to create a white-list of supported JDBC drivers.
To update the supported JDBC Driver Classes:
  1. Open the following file in a text editor:
    /opt/SecureSpan/Gateway/node/default/etc/conf/system.properties
  2. Add the following line to the end of the file. This explicitly adds all the default supported JDBC drivers:
    com.l7tech.server.jdbcDriver=com.mysql.jdbc.Driver\ncom.l7tech.jdbc.mysql.MySQLDriver\ncom.l7tech.jdbc.db2.DB2Driver\ncom.l7tech.jdbc.oracle.OracleDriver\ncom.l7tech.jdbc.sqlserver.SQLServerDriver
  3. Append any new drivers to the end of the previous line using the same format:
    \n
    <JDBC driver class>
    Where
    "<JDBC driver class>"
    is the class name string.
    Optionally, you can remove any deprecated drivers that you no longer support.
  4. Save and exit the file.
  5. Restart the Gateway for changes to take effect.
Changes made to the system.properties file are not reflected in the driver class selection list. Allow easy selection of the driver class by modifying the driver class selection list. Otherwise, you can type the driver in manually when defining a JDBC connection.
If the
com.l7tech.server.jdbcDriver
property is removed, the default drivers are implicitly supported.
Modify the Driver Class Selection List 
The driver class selection list is a drop-down list, accessed when configuring a JDBC connection.
If the driver class is not added to the system.properties file, it cannot be used, regardless of whether it is added to the driver class selection list.
To modify the selection list:
  1. In Policy Manager, go to
    Tasks
    >
    Global Settings
    >
    Manage Cluster Wide Properties
    .
  2. Click
    Add
    .
  3. For
    Key
    , select:
    jdbcConnection.driverClass.defaultList
  4. For
    Value
    , type the any new driver class in the existing list, or remove an existing entry.
  5. Click
    OK
The JDBC interface is enabled when the Gateway is restarted. You can now create JDBC connections and perform JDBC queries.
For more information, see: