Configuring the Sync Server for JDBC sources using supported drivers

This task is part of the main task for Configuring the Sync Server for data sources. When you have completed the steps, return to Configuring the Sync Server to access data sources.

For iSeries drivers:

Be sure to create a collection library using the SQL statement CREATE SCHEMA.

Procedure

To add the JDBC driver to your system's class path:

1. Exit the Mobile Devices Administration Center if it is running.
2. Stop the Sync Server servlet or the service if it is running.
3. Using a text editor, open \Server\bin\dsysetjavahome.bat file file.
4. Add the complete path of the JDBC driver to the SET JDBC_DRV_CP line of the file. For example, to configure access to an Oracle source using the JDBC client driver installed to C:\Oracle\Ora81\jdbc\lib\, add the following path to the SET JDBC_DRV_CP line of the dsysetjavahome.bat file:

   SET JDBC_DRV_CP=C:\Oracle\Ora81\jdbc\lib\classes111.zip
   

   You can specify multiple JDBC client drivers. For example:

   SET JDBC_DRV_CP=C:\Oracle\Ora81\jdbc\lib\classes111.zip;E:\Informix\JDBC\lib
     \ifxjdbc-g.jar
   

5. Adjust the Sync Server properties:
   • Edit the file:

     \WAS\config\cells\DefaultNode\nodes\DefaultNode\servers\DB2eServer\Server.xml
     

   • Add the following line, for example:

     <classpath>C:\Oracle\Ora81\jdbc\lib\classes111.zip<\classpath>

   • You can specify multiple JDBC client drivers.

     <classpath>C:\Oracle\Ora81\jdbc\lib\classes111.zip<\classpath>
     <classpath>E:\Informix\JDBC\lib\ifxjdbc-g.jar<\classpath>
     

6. Restart the Sync Server servlet or the service to make the changes effective.

Related tasks

• Configuring the Sync Server for JDBC sources using supported drivers
• Specifying the JDBC driver in the Mobile Device Administration Center

Related concepts

• Default JDBC drivers list

Related reference

• Lotus Domino data source restrictions