Sunday, February 27, 2011

Purging the SOA Suite dehydration store

While purging the SOA Suite dehydration store is available through PL/SQL packages. It is not straight forwarrd. Sometime you ant to cleanup the whole dehydration store. Just to have some clean environment to start with. In the 'old' days you had some simple SQL to do this. Since SOA 11g, it is more complicated. As I wonder, why it is so complaticated, I do not know.

Marcin Izdebski created a very nice article about purging the SOA 11g dehydration store, including some straight foward script that does the trick! See:

Tuesday, February 08, 2011

OSB: Creating A-Synchronous / Fire-Forget WebService Call

Out of the box, the Oracle Service Bus (OSB) is is handling synchronous services. If you want to make services, a-synchronously, you should add queues (JMS / AQ / DB) in front or behind it. Or use a SOA 11g / BPEL solution.

When you want to create a fire-forget call via OSB, is rather simple. The trick is to send NO response back to the caller, only an HTTP reponse code; 200 or any other.

You could do this by creating a Proxy service. In this Proxy service you create your pipe-line. In the request of the pipe-line you add the stage and other activities to prepare the data to send to your service. This is done by using the publish activity.

The you create a empty routing activity (!). This does the trick. You you can force in the reponse pipe-line the HTTP response code.

The RouteNode1 activity is dummy and empty. In the request pipeline the service is called, via the publish activity.

The Insert Activity, in the stage of the response pipeline, is overriding the HTTP response code in the inbound variable via the XPath query.

as last child of:


in 'Inbound' variable.

You can use this solution also as an entry for a-Synchronous web-service call.

Thanks to Fai Fung, when helping me on performance testing on the 4-node OSB Cluster.