Abstract: BW-JDBC-100034 "Configuration Test Failed. Exception [java.lang.UnsatisfiedLinkError]"

Abstract: BW-JDBC-100034 "Configuration Test Failed. Exception [java.lang.UnsatisfiedLinkError]"

book

Article ID: KB0087052

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:
Description:
========
While connecting to the Oracle DB using thick drivers, the connections fails with the error below.

*********
BW-JDBC-100034 "Configuration Test Failed. Exception [java.lang.UnsatisfiedLinkError] occurred.
*********
Sometimes, after clicking on the test connection, the Designer crashes.


Environment:
=========
All OS

Symptoms:
========
Test DB connection in designer fails and throws the following exception:

BW-JDBC-100034 "Configuration Test Failed. Exception [java.lang.UnsatisfiedLinkError] occurred.

java.lang.UnsatisfiedLinkError: oracle.jdbc.driver.T2CConnection.t2cSetSessionTimeZone(JLjava/lang/String;)I"

Cause:
=====
The issue happens when the required JAR files and the Oracle client bin is not set correctly in the designer.tra file.

Resolution:
==========
Install the Oracle client on the Designer box. If the Oracle DB server is also on the same box, you do not need the client. In that case, you can use the following files from the Oracle server installation.

- Add [ORACLE_HOME]\jdbc\lib\ojdbc5.jar to
your CLASSPATH if you use JDK 1.5 or
[ORACLE_HOME]\jdbc\lib\ojdbc6.jar if you use JDK 1.6.

- Add [ORACLE_HOME]\jlib\orai18n.jar to your CLASSPATH if needed.

- Add [ORACLE_HOME]\bin to your PATH if you are using the JDBC OCI.

Or you can add the above JARs at the beginning of the "tibco.env.CUSTOM_CP_EXT" of the designer.tra file. Go to the link below to configure the thick drivers on different OS's.

http://www.oracle.com/technetwork/database/enterprise-edition/111070-readme-083278.htm

Issue/Introduction

Abstract: BW-JDBC-100034 "Configuration Test Failed. Exception [java.lang.UnsatisfiedLinkError]"

Additional Information

http://www.oracle.com/technetwork/database/enterprise-edition/111070-readme-083278.html