Make the JDBC Drivers Available

To connect with the database, iProcess® Web Services Server Plug-in requires a JDBC driver for the database you are using. During installation, you are asked for the location of the JDBC Driver. Therefore, you need to have a local copy of the JDBC Driver for the database you are using before you start installing iProcess® Web Services Server Plug-in.

If you are using:

SQL Server:

Note 

This applies to all versions of SQL Server.
  1. Download Microsoft SQL Server JDBC Driver 3.0 from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707.

  2. Specify sqljdbc4.jar.

Oracle 18c or 19c, when installing iProcess® Web Services Server Plug-in, specify ojdbc8.jar from your Oracle installation.

Note 

If you are using an older version of Oracle, consult your Oracle documentation for the JDBC driver you need to use.
DB2, specify IBM DB2 JDBC Driver 4.0.

Note 

If you are using DB2, you must set the parameter SWDBUtil.removeConnectionsOnException present in Webservices_server_location/jetty9.4.35/tibco/wsconfig.properties as follows: SWDBUtil.removeConnectionsOnException = true

(Default: false)