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

Get IBM WebSphere Everyplace Access V5 Handbook for Developers and Administrators Volume III: E-Mail and Database Synchronization now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.