This section provides instructions for setting up the RepConnector environment so that RepConnector can communicate with the database to send SQL events that it receives from the messaging system. If you are using Sybase Adaptive Server database, no additional steps are required for RepConnector to communicate with the database.
Sybase recommends that you configure your environment before you configure the RepConnector connection. This enables you to ping the database during configuration to verify that the connection is configured correctly.
Configuring for an Oracle database
Verify that the lines in the repra_env.bat file on Windows or repra_env.sh file on UNIX that define the CLASSPATH/BOOTCLASSPATH environment variable, are not commented out, and point to the installation location for your database environment.
On Windows:
CLASSPATH=d:\oracle\ora92\jdbc\ojdbc14.jar;%CLASSPATH% BOOTCLASSPATH=d:\oracle\ora92\jdbc\ojdbc14.jar;%CLASSPATH%
On UNIX:
CLASSPATH= /work/oracle/ora92/jdbc14.jar;$CLASSPATH BOOTCLASSPATH= /work/oracle/ora92/jdbc14.jar;$BOOTCLASSPATH
Restart your application server.
