This article intends to provide guidance on choosing an Oracle JDBC driver version for your TIBCO Streaming applications. 

This article provides some notes on version compatibility between TIBCO Streaming and the Oracle JDBC driver.

JDBC driver compatibility depends primarily on the version of the Oracle database being used. Oracle does try to address compatibility questions HERE.

First, refer to the FAQ "What is the JDBC and RDBMS interoperability matrix or the certification matrix?".  Here, Oracle states: "The recommendation is that JDBC driver version should always be either same as or higher than the Oracle database version in order to leverage the latest capabilities of the driver."  Although the matrix itself doesn't reference any TIBCO products, that statement implies that you can use a version of the jdbc driver that is newer than your Oracle database version. For example, the matrix shows that for Oracle 12.1, you can potentially use the very latest jdbc version (currently v21.1).

Also consider the FAQ "What are the Oracle JDBC releases Vs JDK versions?".  This is important, because you must ensure you're using a version of the driver that supports your Oracle version as well as the version of the JDK making use of the jdbc driver jar.  In the case of Streaming 10.6 for example, that is JDK version 11. In the table shown for this FAQ, you can see that ojdbc8 and later support JDK 11.

For details on what versions of the Oracle database are supported with TIBCO Streaming, refer to the Help under Home > Installation Guide > Supported Configurations > (table-heading) External JDBC-compliant databases.