Why does the database connection from BusinessConnect to an Oracle database fail when using the ojdbc14.jar jar with the "oracle.jdbc.OracleDriver" driver class.

Why does the database connection from BusinessConnect to an Oracle database fail when using the ojdbc14.jar jar with the "oracle.jdbc.OracleDriver" driver class.

book

Article ID: KB0089143

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect -
Not Applicable -

Description

Resolution:
Description:
============
Unable to configure the Oracle Thin driver connection string in BusinessConnect
 
Environment:
==========
BusinessConnect 5.3.0 and above
 
Cause:
=====
There are two Oracle thin drivers with different JDBC driver class signatures. For the ojdbc14.jar file, the JDBC driver class signature is "oracle.jdbc.driver.OracleDriver".  With ojdbc6.jar (Oracle 11g and up), the class signature "oracle.jdbc.OracleDriver".
 
Resolution:
=========
Use the correct driver signature with the correct Oracle driver jar file.

Issue/Introduction

Why does the database connection from BusinessConnect to an Oracle database fail when using the ojdbc14.jar jar with the "oracle.jdbc.OracleDriver" driver class.