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:
Open the Dynamo Administration UI (
http://
hostname:port/dyn/admin) and click on the Configuration Manager link.Click on the name of the server you want to configure. The configuration page for that server opens.
In the Configure Dynamo Services section, click on System Paths.
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.jarOracle 8i Thin and OCI
JDBC_LIB_DIR
/classes12.zipOracle 9i Thin and OCI
JDBC_LIB_DIR
/ojdbc14.jarAfter you enter the CLASSPATH, click the Append to CLASSPATH button. For more information about setting the CLASSPATH, see the documentation for your JDBC driver.
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
/libORACLE_HOME
/jre11/libAfter 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.
Stop your ATG web application and restart the application server.