Overview

When you try to connect a Microsoft SQL database using DB Adapter in BPM Studio the connection fails with a ClassNotFoundException error.  The following is an example of the ClassNotFoundException error that states it is not able to find the com.microsoft.sqlserver.jdbc.SQLServerDriver: 

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver cannot be found by com.aurea.cxprocess.studio.adapters_10.0.20.202003111631
        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)

Prerequisites

• Aurea Process BPM Studio 2018 or later that will be used in conjunction with Microsoft SQL Server

Solution

Diagnosis

As of Aurea Process 2017, BPM Studio is no longer bundled with any vendor-specific JDBC drivers out of the box. 

Solution Steps

Before executing the following steps to resolve the issue with DB Adapter in BPM Studio, you will need to download the Microsoft JDBC Driver 8.2 for SQL Server from the Microsoft site.  The Microsoft SQL Server Driver 8.2 download will include the required mssql-jdbc-8.2.2.jre8,jar file.

Once you have downloaded the mssql-jdbc-8.2.2.jre8.jar file, the steps to resolve this issue are as follows:

• Stop the BPM Studio if it is running.
• Go to STUDIO_HOME\customplugins
• Copy the folder com.aurea.cxprocess.studio.jdbc.mssql.lib_10.0.XX.XXXXXXXXXXXX and paste it under STUDIO_HOME\eclipse\plugins directory.
• Copy the mssql-jdbc-8.2.2.jre8.jar that you download into the STUDIO_HOME\eclipse\plugins\com.aurea.cxprocess.studio.jdbc.mssql.lib_10.0.XX.XXXXXXXXXXXX\lib directory.
• Start the BPM Studio.