Having multiple versions of Oracle drivers within the class path may lead to errors. For example, the error "ORA-00942: table or view does not exist" will be seen even if the table/view does exist.

Having multiple versions of Oracle drivers within the class path may lead to errors. For example, the error "ORA-00942: table or view does not exist" will be seen even if the table/view does exist.

book

Article ID: KB0089939

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
===========
Having multiple versions of Oracle drivers within the class path may lead to errors. For example, the error "ORA-00942: table or view does not exist" will be seen even if the table/view does exist.

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

Resolution:
=========

Do the following to find out what driver jars are loaded in the BE engine:

- Append " --debug &gtdebug.out" when starting the BE engine. In this way all of the jars loaded by engine will be logged to the debug.out file. For example, be-engine --propFile BE_HOME\bin\be-engine.tra -u default -c FraudDetection/fd.cdd fd.ear --debug &gtdebug.out

- Search ojdbc or classes12 in the debug.out to find all occurrences.

If you do find more than one occurrence in the file, keep only one jar in the class path and move the other jars out of the TRA path.

Issue/Introduction

Having multiple versions of Oracle drivers within the class path may lead to errors. For example, the error "ORA-00942: table or view does not exist" will be seen even if the table/view does exist.