IBM WebSphere Everyplace Access V5 Handbook for Developers and Administrators Volume III: E-Mail and Database Synchronization

Chapter 4. Synchronizing with Oracle databases 271

rem dsysetjavahome.bat: set the java/jre path & classpath

rem -----------------------------------------------------------------------

for %%i in ("%DSYINSTDIR%") do (set DSY_INSTDIR=%%~sfi)

set JAVA_HOME=C:\WebSphere\DB2Everyplace/Uninstaller/jvm/jre

rem for jdk 1.2.X and 1.3.X

SET JDK_EXTRA_CP=.

rem for jdk 1.1.X

rem SET

JDK_EXTRA_CP=%DSYSQLLIBINSTDIR%\java\jre\lib\i18n.jar;%DSYSQLLIBINSTDIR%\java\j

re\lib\rt.jar;%DSYSQLLIBINSTDIR%\java\swingall.jar

rem jdbc drivers

SET JDBC_DRV_CP=c:\oracle\ora92\jdbc\lib\classes12.zip

4.4 Synchronize with remote Oracle database

To create a subscription to synchronize with the Oracle data source that is on a

separate machine, follow the same steps illustrated in 4.2, “Create a subscription

with Oracle data source” on page 257.

4.5 Hints and tips

In addition to the hints and tips given in 3.13, “Hints and tips” on page 253,

consider the following:

򐂰 If you get the following error, check to make sure the Oracle JDBC driver is in

the classpath of IBM DB2 Everyplace Server, and that this server has been

properly restarted with no errors.

DSYD007, MDSS connection pool encountered the exception: unable to register

JDBC driver for ......

򐂰 If you cannot make a test connection within MDAC to the Oracle database,

check to make sure JDBC_DRV_CP is properly configured in

dsysetjavahome.bat, and IBM DB2 Everyplace Server has been restarted to

take in the change.

272 IBM WebSphere Everyplace Access V5 Handbook for Developers and Administrators Volume III: E-Mail and Database Synchronization