Configuring the Sync Server for JDBC sources using unsupported drivers

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

Procedure

To configure the Sync Server using unsupported JDCB drivers:

• create a new row in the DB2 Everyplace control database (DSYCTLDB) and provide the appropriate values.
• add the JDBC driver to your system's class path

To update the dsy.properties table in the DB2 Everyplace control database:

1. Exit the Mobile Devices Administration Center.
2. Stop the Sync Server servlet.
3. Create a new row in the DB2 Everyplace control database (table = dsy.properties; colums = TYPE, NAME, and VALUE) .
   • For the TYPE column, enter DSYJdbcDriverList
   • For the NAME column, enter the name of the driver (for example, com.jnetdirect.jsql.JSQLDriver)
   • For the VALUE column, enter the value for the driver that you are using (for example, SQLServer)

   A utility is provided, the dsysetproperty.bat to query and update the DB2 Everyplace properties table in the DB2 everyplace control database.

   • For Windows, you can find dsysetproperty.bat located in %DSYINSTDIR%\Server\bin.
   • For UNIX, dsysetproperty.sh is located in $DSYINSTDIR/Server/bin.Using a text editor, open DSYJdbcDriverList.properties file in \Server\classes\com\ibm\mobileservices\ directory.
4. Restart the Sync Server servlet to effect the changes.

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 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. Restart the Sync Server servlet 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