Oracle Fusion, BPEL and coordination of master- and detail processes

Because of a little illness Lucas was a bit faster with the publish of his article :) but i decided to still post it on my blog. In the new Fusion 11g, Oracle added a new extension to the bpel language for the coordination of master- and detail processes. With this add on it is possible to relate a master process with his detail processes and give signals to each other when to start and when parts are finished. Let's start with building something We created a new composite application...

Oracle Domain Value Maps and Business Rules runtime edit with SOA Composer

Last week there was a question on the forum how to add values to the domain value maps on runtime. In the Oracle SOA Suite 10g we could maintain those values from the console. In Fusion 11g it's a little bit different. Oracle now supplies us a new tool called SOA Composer (patch set 1). This new tool can be used to maintain both rules and domain value maps at runtime. Create a new composite and add a dvm to it Create a new dvm Select the project, goto File > New > SOA...

Install Oracle Fusion11g repositories on 11g db

The rcu installer does a db prerequisite check on the version of the db you're installing on. Since i'm using the 11.1.0.6.0 version the installer would fail with the message 'The database you are connecting is not a supported version. Enter Database with version equal to or higher than 10.2.0.4.0 in 10g or version equal to higher than 11.1.0.7.0 in 11g. Refer to the certification matrix for supported DB versions'. Go to the file [sourcecode...

Jumpstart for Oracle Service Bus Development

The article which i wrote together with Ronald van Luttikhuizen is posted on the OTN site. My first one for OTN and i'm proud of it. If you still have any questions about it or other related subjects, i will be happy to help you. link : Jumpstart for Oracle Service Bus Development Download resources (OSB + Java) Original...

Oracle SOA Suite 11g, Setting and Getting Preferences

In Oracle Bpel 10g we had the functionality to add preferences to your bpel process. By adding the next xml to the bpel.xml file we could get the value as variable into our process and change the value from the console. [sourcecode language="xml"] MyCurrentValue [/sourcecode] In the new Oracle SOA 11g things changed a little but. Like Marc already described in his blog we now need to add the preferences to the composite.xml of our Composite Application. Add the next xml to the...

Oracle Service Bus, JMS Request/Response pattern

Inspired by the article of Edwin about JMS Request Reply Interaction Pattern in Soa Suite 11g, i will show a little example of what functionality Oracle Service Bus supplies to implement the jms request/response (reply) pattern. The solution is quiet simple. Create the wls resources Create JMS Server, MyJMSServer Create JMS Modules, MyJMSResources Create a Connection Factory, MyConnectionFactory Create 2 queues, MyQueueIn (request message), MyQueueOut (response message) Create...

Oracle Service Bus, transporting large files fails

Error [sourcecode language="xml"] weblogic.socket.MaxMessageSizeExceededException: Incoming message of size: '20000160' bytes exceeds the configured maximum of: '20000000' bytes for protocol: 't3'. weblogic.socket.MaxMessageSizeExceededException: Incoming message of size: '20000160' bytes exceeds the configured maximum of: '20000000' bytes for protocol: 't3' at weblogic.socket.AbstractMuxableSocket.incrementBufferOffset(AbstractMuxableSocket.java:262) at...

Evaluating xpath expressions

This week we were messing around with a routing problem in one of the Oracle Service Bus projects. We had an if-then-else construction which selects on the payload to see what transformation is needed and which business service it needs to call. Example payload [sourcecode language="xml"] VALUE1 1 VALUE2 10 [/sourcecode] test1 : /EDI/CONF_UNB/SYNTAX_ID result : node SYNTAX_ID with value 'VALUE1' test2 : count(/EDI/CONF_UNB/SYNTAX_ID) = 1 result :...

Book review : Oracle SOA Suite Developer's Guide

Oracle SOA Suite Developer's Guide Finally i had some spare time to read this nice book! It's real bookshelf filler with 621 pages. The book already got released before fusion 11g went live, but it was still nice to get some more information about the 'old' soa-suite stack. Over at IT-eye we did quiet some soa implementations with the Oracle stack, so i already had good background on the information discussed in the book. What i particularly was interested in was the best practices of...

Oracle Service Bus, publish small/big messages to Oracle AQ endpoint

The weird thing was for certain responses i couldn't find the payload back when i queried the aq table in the database. [sourcecode language='sql'] select qt.user_data.text_vc , qt.user_data.text_lob from my_aq_table qt [/sourcecode] The process just completed succesfull in osb, but the payload wasn't there (well it looked like it wasn't there). When publishing big payloads to an Oracle AQ endpoint, Oracle (db) will decide weither the payload will get stored either as...