Modify the CLASSPATH and native library path environment variables to indicate the path location of the JDBC driver associated with your DBMS.

You can change these path settings through the Dynamo Configuration Manager:

  1. Open the Dynamo Administration UI (http://hostname:port/dyn/admin) and click on the Configuration Manager link.

  2. Click on the name of the server you want to configure. The configuration page for that server opens.

  3. In the Configure Dynamo Services section, click on System Paths.

  4. On the Configure System Paths page, under Extend Dynamo’s CLASSPATH (append), enter the full path to the Java classes for the JDBC driver in the New classpath value field.

    The table below lists the CLASSPATH for several JDBC drivers. JDBC_LIB_DIR refers to the directory where your driver files are stored.

    JDBC Driver

    CLASSPATH

    IBM DB2 UDB

    JDBC_LIB_DIR/db2jcc.jar

    Oracle 8i Thin and OCI

    JDBC_LIB_DIR/classes12.zip

    Oracle 9i Thin and OCI

    JDBC_LIB_DIR/ojdbc14.jar

    After you enter the CLASSPATH, click the Append to CLASSPATH button. For more information about setting the CLASSPATH, see the documentation for your JDBC driver.

  5. If you are using a JDBC Type 2 driver, you must set the native library environment variable. In the Set the Native Library environment variable section, under Extend Dynamo’s native libraries (append), enter the full path to your JDBC driver library in the New native library path value field.

    The table below lists the native library path for an Oracle OCI driver. In the table, ORACLE_HOME refers to your main Oracle directory.

    JDBC Driver

    Native Library Path

    Oracle OCI

    The directory that contains your OCI driver’s .dll and .so files and the directory that contains your driver’s JRE library. For example:

    ORACLE_HOME/lib
    ORACLE_HOME/jre11/lib

    After you enter the native library path, click the Append to Native Library Path button. For more information about setting the native library path, check the documentation for your JDBC driver.

  6. Stop your ATG web application and restart the application server.

 
loading table of contents...