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