“JDBC connection Test Failed: Class not found oracle.jdbc.OracleDriver” error in studio for Business Events (BE) 5.0.0 even though the Oracle driver was placed in the correct directories for BE 4.0.1.

“JDBC connection Test Failed: Class not found oracle.jdbc.OracleDriver” error in studio for Business Events (BE) 5.0.0 even though the Oracle driver was placed in the correct directories for BE 4.0.1.

book

Article ID: KB0084451

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Environment:
==========
This Solution is specific to BE 5.0.0 on any platform.

Symptoms:
=========
JDBC test connection fails with the following stack:

JDBC connection test failed.

Class not found: oracle.jdbc.OracleDriver

java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:483)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:399)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:387)
    at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:87)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at com.tibco.cep.sharedresource.jdbc.JdbcGeneralPage.n(Unknown Source)
    at com.tibco.cep.sharedresource.jdbc.JdbcGeneralPage.a(Unknown Source)
    at com.tibco.cep.sharedresource.jdbc.JdbcGeneralPage$1.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

Cause:
=====
The ojdbc*.jar file is in the wrong location.  Copy the appropriate JDBC drivers file (for example, ojdbc6.jar) to BE_HOME/lib/ext/tpcl.

Note, with BE 5.0.0 you should not use either classes12.jar file or ojdbc14.jar because those jar files are meant for earlier versions of Java.  The ojdbc6.jar file from Oracle 11.x should be used.

Resolution:
=========
See explanation under Cause.

References:
==========

Point 2 on page 65 of "TIBCO BusinessEvents Getting Started".  

Note that the documentation for TickerTracker demo under Views has incorrectly documented this on page 44 of TickerTrackerStepByStep.pdf :

1). Copy the Oracle JDBC Thin driver libraries (classes12.zip) to BE_HOME/lib/ext.

Issue/Introduction

“JDBC connection Test Failed: Class not found oracle.jdbc.OracleDriver” error in studio for Business Events (BE) 5.0.0 even though the Oracle driver was placed in the correct directories for BE 4.0.1.