BPM 12c Error: SQL Server Database Insert Issue (Doc ID 2106416.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Business Process Management Suite - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

A BPM process calls a DB operation using DB adapter. When the DB operation is performed the following error shows up in the logs:

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
at org.eclipse.persistence.sessions.DatasourceLogin.setPlatformClassName(DatasourceLogin.java:510)
at oracle.tip.adapter.db.DBManagedConnectionFactory.buildServerSessionConnectivity(DBManagedConnectionFactory.java:1276)
at oracle.tip.adapter.db.DBManagedConnectionFactory.buildServerSession(DBManagedConnectionFactory.java:1409)
at oracle.tip.adapter.db.DBManagedConnectionFactory.createServerSession(DBManagedConnectionFactory.java:1232)
at oracle.tip.adapter.db.DBManagedConnectionFactory.acquireSession(DBManagedConnectionFactory.java:664)
at oracle.tip.adapter.db.transaction.DBTransaction.getSession(DBTransaction.java:382)
at oracle.tip.adapter.db.DBConnection.getSession(DBConnection.java:263)
at oracle.tip.adapter.db.DBInteraction.executeOutboundWrite(DBInteraction.java:866)
at oracle.tip.adapter.db.DBInteraction.execute(DBInteraction.java:300)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms