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.
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.