Skip to main content

This is the 5th of a 5 part series that explains how to expose a database to an Oracle BPM 12c Process using the Oracle SOA Database Adapter and a Mediator. In this, the Composite with the Database Adapter created in part 4 is invoked by the Oracle BPM process using a Service activity.
This is the 4th of a 5 part series that explains how to expose a database to an Oracle BPM 12c Process using the Oracle SOA Database Adapter and a Mediator.
This is the third in a series of 5 blogs that shows how to expose a database to an Oracle BPM 12c Process using the Oracle SOA Database Adapter.  In this blog, the Database Adapter's Outbound connection pool created in part 2 of this series is configured to include the data source's JNDI name created in part 1 of this series.
This is the second in a series of 5 blogs that shows how to expose a database to an Oracle BPM 12c Process using the Oracle SOA Database Adapter. In this blog, the Database Adapter's Outbound Connection Pool is configured.
This is the first in a series of 5 blogs that shows how to expose a database to an Oracle BPM 12c Process using the Oracle SOA Database Adapter. In this blog, the WebLogic JNDI connection to a database schema is created.  

Some companies create database schemas that are either prefixed or suffixed with the environment name. This can cause a problem when using the Oracle Database Adapter to execute a stored procedure. When adding a database adapter to a project, one must specify the schema in which the stored procedure was created. Even if <Default Schema> is selected, the schema JDeveloper is connected to the database with will be specified in JCA file that is created.

 

The Problem

Sometimes, when deploying a BPM composite, the deployment times out. When a BPM composite deployment fails in this way, it does not clean up after itself. It leaves several records in the database. If one attempts to deploy the same revision, it will also fail. A common workaround is to restart the managed servers, increment the version number, and attempt the deploy again.

While the workaround does work, the remnants of the bad deploy will result in the flex field headers not displaying correctly in the workspace.

If you have struggled getting the demo community users loaded for Oracle SOA Suite and BPM in 12c, you are not alone. Quite a bit has changed with Oracle’s demo community seed application we’ve been using for years.  The purpose of this is to help you get the demo users seeded for your 12.2.1.2 installation.

Business Process Management (BPM) is an important part of many organizations. Many experts agree that BPM is not only important for business operations, it is a necessary component for handling change. There can be changes in assignments, changes in back-end systems and changes in workflow are just some examples. However when changes occur, it has been up to IT to implement and up to the business managers to manage the fallout. We all know change is painful, and the more we can place change control in the hands of the business managers, the better the organization can manage change.

Oracle SOA Database Adapters provide a polling mechanism that will periodically query a table to see if a there is a new or changed record.  If so, it can trigger a BPEL process.  This is enormously useful.  However, on one client I ran into a series of issues with database pollers in a clustered environment when they … collided.  (queue dramatic music)

Subscribe to BPM