BPM 12c Error: SQL Server Database Insert Issue

When I was trying to perform insert operation in BPM  (12C) process, i got following exception

Could not invoke operation 'insert' against the 'db' due to: [[
BINDING.JCA-11622
Could not create/access the TopLink Session.
This session is used to connect to the datastore.
Caused by Exception [EclipseLink-7042] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.ValidationException
Exception Description: Database platform class [weblogic.jdbc.sqlserver.SQLServerDriver] not found.
Internal Exception: java.lang.ClassCastException: weblogic.jdbc.sqlserver.SQLServerDriver cannot be cast to org.eclipse.persistence.internal.databaseaccess.Platform.
You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server. This exception is considered not retriable, likely due to a modelling mistake.
]]

The error is followed by an exception with the following stack trace:
java.lang.ClassCastException: weblogic.jdbc.sqlserver.SQLServerDriver cannot be cast to org.eclipse.persistence.internal.databaseaccess.Platform

It was very hard to find out the reason. Even google did not help much. With the help of oracle support we came with following reasons for the error.

1. The DB adapter configuration for the connection pool ( Weblogic console -> Deployments -> DbAdapter -> Configuration ->outbound connection pool has incorrect setting for the platformClassName property.
  Outbound Connection pool) 
for the given co
 Depending on the class set there you may see different  java.lang.ClassCastException source classes

2. There was some  incorrect configuration specified in the weblogic-ra.xml

3. The Plan.xml files were different on different servers.


Solution: 


1. Set the correct platformClassName value for the DB Adapter configuration pool within Weblogic console -> Deployments -> DbAdapter -> Configuration -> Outbound Connection pool -> <Your pool>

For Oracle DB connection the platformClassName should have the org.eclipse.persistence.platform.database.Oracle10Platform and for Microsoft SQL server it should have org.eclipse.persistence.platform.database.SQLServerPlatform

Notice that the class is always in the org.eclipse.persistence.platform.database package and extends the org.eclipse.persistence.platform.database.Platform class


2. Please refer to the documentation: https://docs.oracle.com/cd/E24329_01/web.1211/e24971/creating.htm#ADAPT129
 and confirm the weblogic-ra.xml file is correct

3. Please ensure the Plan.xml files are identical in all servers.

Oracle BPM - Importing Visio Processes into Oracle 12C BPM Studio

Introduction

Sometime Business User/Business Analyst works on different process modeling tools while defining business use cases raher than Oracle BPM. In that case developers has to covert that models to Oracle BPM format. In Oracle BPM 12C its very easy to import BPM model from third party applications like Visio, Oracle Tutor, BPMN 2.0, Oracle Workflow, XPDL etc.

In this blog we will cover how to import Visio process model into Jdeveloper BPM studio.

Import Visio Process into BPM Studio

I have used a sample visio process model for this blog which i downloaded from Oracle Site. Visio project should be exported in form of  ".vdx" file.



We can open this file in Internet Explorer.

Visio Process

Steps to import Visio process file

 

1. Create a BPM application



 2.  Give Application name "LoanApplication"




3. Create a BPM project LoanRequestProject with empty composite





 4. From file menu select import




 5. Select "Import process model from external tool" option



6. Click Next



7. Select Visio option and browse the file from local folder



8. Keep default option and click Next



9.  From drop down list select <Pool> option and click  Finish. This option defines naming pattern for the bpm process.



10. After succesfull import, we will see following message



11. Refresh BPMN process folder. We will see new BPM process under that.




12. Open new BPM process.




This is how BPM process looks like. It's same as shown in Visio diagram.

Similarly, we can import other modeling formats like XPDL into BPM studio.