JDBC drivers supported by Business Process Framework V4.1

The IBM FileNet P8 V5.0 Hardware and Software Requirements document, which is available from the IBM Support Portal at https://www.ibm.com/support/pages/node/320921, states that IBM FileNet P8 supports the following JDBC drivers:

• For Microsoft SQL Server, the Microsoft JDBC driver version that corresponds to the Microsoft SQL Server version is supported.
• For Oracle, the JDBC driver version that corresponds to the Oracle database version is supported.

Business Process Framework V4.1 supports the following JDBC drivers:

• For Microsoft SQL Server, jtds-1.x.y.jar is supported.
• For Oracle, ojdbc14.jar is supported.

Does Business Process Framework support the same JDBC drivers as IBM FileNet P8?

At the time of this publication, Business Process Framework V4.1 supports the following JDBC drivers:

• For Microsoft SQL Server, the following drivers are supported:
  • jtds-1.x.y.jar is supported.
  • sqljdbc.jar is supported for BPF Web only.
  • sqljdbc4.jar is supported for BPF Web only.
• For Oracle, the following drivers are supported:
  • ojdbc14.jar is supported.
  • ojdbc5.jar is supported.
  • ojdbc6.jar is supported.

Business Process Framework V4.1 supports the same JDBC drivers as IBM FileNet P8 V5.0 with the exception that BPF Operations supports only the jtds-1.x.y.jar driver for Microsoft SQL Server.

Important: To use Business Process Framework with the following drivers, you must implement the workaround described later in this document:

• sqljdbc.jar
• sqljdbc4.jar
• ojdbc5.jar
• ojdbc6.jar

Remember: For Microsoft SQL Server, BPF Operations requires the jtds-1.x.y.jar driver. If the BPF metastore database is Microsoft SQL Server, you must download and install the jTDS JDBC driver regardless of the JDBC driver that you use for the BPF Web Application. You can download the jTDS JDBC driver from http://sourceforge.net/projects/jtds/files/.