Overview
You get ClassNotFoundException for the driver class while connecting to Oracle database using Managed DB Adapter in BPM Studio version 2018 or 2019. You tried with the driver oracle.jdbc.driver.OracleDriver though the 2019 documentation still shows that the DataDirect driver should be used.
The full error:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver cannot be found by com.aurea.cxprocess.studio.adapters_10.0.18.201909301535 at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:439) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:352) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:344) at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:160) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:190) at com.savvion.sbm.adapters.db.DatabaseHelper.getConnection(DatabaseHelper.java:232) at com.savvion.sbm.adapters.db.StatementEditor.conBtn_actionPerformed(StatementEditor.java:842) at com.savvion.sbm.adapters.db.StatementEditor$7.actionPerformed(StatementEditor.java:557) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
Solution
Note: This article applies to EOL versions of the product (versions 2018 and 2019). It is recommended to upgrade to the latest version.
BPM Studio doesn't bundle any vendor-specific drivers out of the box.
The steps to resolve this issue are the following:
- Stop the Studio if it is running,
- Go to STUDIO_HOME\customplugins
- Copy folder com.aurea.cxprocess.studio.jdbc.oracle.lib_10.0.XX.XXXXXXXXXXXX and paste it under STUDIO_HOME\eclipse\plugins directory.
- Copy ojdbc7.jar under STUDIO_HOME\eclipse\plugins\com.aurea.cxprocess.studio.jdbc.oracle.lib_10.0.XX.XXXXXXXXXXXX\lib directory.
- Start the Studio.
Note: We have updated our Managed Adapter Guide with a detailed description of how to configure the Database Adapter (see chapter Configuring the Database Adapter).
<supportagent>
Agent-only: documentation defect (fixed): SBM-66402
</supportagent>