Configuring DA Server to Use the Oracle JDBC Driver

Configure the DA server to use the ojdbc.jar Oracle JDBC driver JAR file, before performing a heterogeneous comparison.

Obtain the JDBC driver JAR file from your Oracle installation directory.
For example, in Oracle 10.2.0, the JAR file is in:
- On Windows – %ORACLE%\product\10.2.0\server\jdbc\lib\ojdbc14.jar
- On UNIX – $ORACLE/product/10.2.0/server/jdbc/lib/ojdbc14.jar
Copy the ojdbc14.jar file into the DA library folder:
- On Windows – %SYBASE%\DA-15_5\server\lib\drivers\ojdbc14.jar
- On UNIX – $SYBASE/DA-15_5/server/lib/drivers/ojdbc14.jar
where %SYBASE% (Windows) or $SYBASE (UNIX) is the directory in which you installed the Data Assurance Option, and lib is the library folder of your DA server instance.
Note: You need not copy the driver file, if the JAR file is available to the DA server on the same file system.
Open and configure the RUN start-up script file:
- On Windows 32-bit:
```
%SYBASE%\DA-15_5\server\instance\RUN_instance_32.bat
```
- On Windows 64-bit:
```
%SYBASE%\DA-15_5\server\instance\RUN_instance_64.bat
```
- On UNIX:
```
$SYBASE/DA-15_5/server/instance/RUN_instance_64.sh
```
where:
- %SYBASE% (Windows) or $SYBASE (UNIX) is the directory in which you installed the Data Assurance Option.
- instance is the name of your DA server.
- RUN_instance_32.bat or RUN_instance_64.bat is the start-up script file on Windows.
- RUN_instance_64.sh is the start-up script file on UNIX.
Add the location of the Oracle JDBC driver JAR file to the DA server CLASSPATH.
On Windows:
```
set CLASSPATH=%CLASSPATH%;%DA_LIB%\drivers\ojdbc14.jar
```
On UNIX:
```
set CP=$CP:$DA_LIB/drivers/ojdbc14.jar
```
Note: If you do not copy the driver file into the DA server lib directory, enter the absolute path to the driver file in the Oracle installation directory.
Save the RUN start-up script file.
Restart the DA server for the settings to take effect.

Follow the same steps to configure a DA agent to use the Oracle JDBC driver JAR file.