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