BPEL 11g threads in parallel flow

A lot has been written about the transactions, boundaries, threads etc in the Oracle SOA Suite. Clemens has written this piece years ago which explains the basics.I recently had a ‘disagreement’ with the SOA threadpool when I was using a parallel flow in a synchronous BPEL process.

The requirement was to guard the execution time of this BPEL process to a predefined maximum amount of seconds. The environment is as such that tweaking the (more...)

SOA DbAdapter lingo: java.sql.SQLException: setObject, Exception = 8

In the many years that I work with the Oracle SOA Suite and its Database Adapter, I never really had the pleasure of encountering the setObject errors.

Normally when you screw up the IN parameters in your call to the Database Adapter you’d get those java struct  “cannot convert STRING to NUMERIC” errors. However, the following message

Set object error.
Error binding the value of parameter P_SOMEINPUT.
An error occurred when binding the  (more...)

Create a 12c development server from the SOA 12c Quickstart

So at the time of writing there is only the “Quickstart” 12C SOA and BPM. That’s all fun and games, it installs straight out of the box.

However,  I want a real development environment, and run it on my dev server.

So, first thing first.

  1. Download the SOA Suite and BPM 12c.
  2. Then install the SOA Suite quick installer.
  3. Install BPM 12c in the same ORACLE_HOME as the SOA Suite.
  4. Make sure you have a (more...)

Getting started with Oracle Service Bus 12c: importing 11g sources

Oracle has finally announced 12c, so now everybody can get their hands on it. One of the new features is that Oracle Service Bus development is integrated into Oracle jDeveloper Studio.

One way to get started quickly is by simply importing your 11g service bus sources into 12c.

First export your 11g sources, either from the Servicebus Console or Eclipse (OEPE):

Export from OEPEThen, this sbconfig.jar is easily imported into the new Oracle jDeveloper Studio (more...)