How to use DataDirect JDBC Drivers from TRA 5.6.x installation with BW 5.9.0 / TRA 5.7.0

How to use DataDirect JDBC Drivers from TRA 5.6.x installation with BW 5.9.0 / TRA 5.7.0

book

Article ID: KB0089600

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:
Abstract:  How to use DataDirect JDBC Drivers from TRA 5.6.x installation with BW 5.9.0 / TRA 5.7.0


Description:
============
In TRA 5.7.0, we have not bundled Datadirect drivers, these drivers are normally made available under tra\tpcl\jdbc folder in prior versions of TRA. This lead to errors in customer environment.


Environment:
===========
   o All environments
   o TRA 5.7.0
   o All hardware

Symptoms:
========
At runtime bwengine will try to load the jdbc driver jar files from tra\tpcl\jdbc folder that does not exist resulting in error.

Cause:
=====
There is no tra\tpcl\jdbc folder in TRA 5.7.0 installation.

Resolution:
==========
If customer has previous TRA version such as 5.6.x, they can either copy /tibco/tpcl/5.6/jdbc directory which contains all the JDBC jar files to tibco/tpcl/5.7/jdbc.

Alternatively, in BW/5.9/bin/bwengine.tra, they can  point out  ‘tibco.env.STD_EXT_CP’ to /tibco/tpcl/5.6/jdbc directory.

If customer does not have previous TRA versions, then they need to use vendor supplied native JDBC drivers.

Issue/Introduction

How to use DataDirect JDBC Drivers from TRA 5.6.x installation with BW 5.9.0 / TRA 5.7.0