New: Oracle Cloud Adapter SDK

A cool thing I heard at Open World 2014: we all know in SOA there are all these adapters you can use in your SCA components. In Oracle Integration Cloud Services (ICS) there are a lot of new SaaS adapters to integrate with SaaS applications like SalesForce for example. These adapters are build using a Cloud Adapter SDK and written in Java.

This exact SDK will be available for users as well, so we all (more...)

JSON is flowing through SOA’s veins

This year’s Oracle Open World is again all about Cloud and Mobile. However, this year it is getting more and more concrete. Apart from all the announcements of Process Cloud and integration cloud services there will be more JSON support in Oracle’s SOA Suite.

In Oracle SOA Suite 12C (12.1.3) the REST Adapter already made its appearance. This adapter makes it make your SCA component available as, and leverage REST services, using JSON. (more...)

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

BINDING.JCA-11808
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...)