BusinessConnect database connection stops working after Oracle database driver upgrade.

BusinessConnect database connection stops working after Oracle database driver upgrade.

book

Article ID: KB0089724

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect -
Not Applicable -

Description

Resolution:
Description
==========
When upgrading our Oracle installation, the ojdbc14.jar was upgraded to ojdbc6.jar. After the upgrade, BusinessConnect stops working.  It  throws the error:

java.sql.SQLException: Cannot match driver: oracle.jdbc.driver.OracleDriver, with url

Environment
===========
TIBCO BusinessConnect  5.X.X

Cause
===========
The Oracle driver java signature has changed in ojdbc6.jar.  The new signature is "oracle.jdbc.OracleDriver".  Ojdbc14.jar used "oracle.jdbc.driver.OracleDriver"

Resolution
==========
Update the driver signature in the "Manage Installation" screen of the BusinessConnect installation, as well as all otther JDBC connection.  BusinessConnect 5.3.X and BC 6.X use the ojdbc6.jar signature by default.

Issue/Introduction

BusinessConnect database connection stops working after Oracle database driver upgrade.