Author Archives: jvzoggel

About jvzoggel

Middleware Consultant / the Netherlands / 's-Hertogenbosch /

How to use the Domain Value Map (DVM) in Oracle Service Bus 12c


Due to the tighter integration of Oracle Service Bus 12c in the whole Oracle SOA Suite product it’s now much easier for developers to use general SOA Suite components like the Domain Value Map (DVM).

Getting Started

First I use the OSB 12c clone project ability to copy th earlier created/blogged OSB 12c Database adapter project and create a project named GetCaseServiceDVM. In the new project we add a Domain Value Map (DVM):


The file name and description speak for themself. The Initial DVM Entries forces us to define the minimum amount of 2 domain names (source and target of our value) and if we want we can inmediately configure the 1st record here.


The result is a DVM file in our project which we can easily edit within JDeveloper 12c.
For this blogpost we will add 2 records which will allow us to translate the value “1” and “2” which we receive from the database to a basic description of that value.


In our XSLT transformation we can drag the DVMFunctions:lookupValue on our canvas.
(You can easily find the function using the search function in components)



Finally we can configure the DVM input fields with the 5 arguments:

  1. The relative path (including the SBProject to your DVM file without mentioning the .DVM extension)
  2. Source table
  3. mapping of the input element we want to translate
  4. Target table to retrieve that specific output value
  5. Default value, in case no match was found in the DVM


In the source code of the XSLT this will look like this:

<tns:Type id="{/ns0:OutputParameters/ns0:GET_CASE_BY_CASENUMBER/ns0:CASETYPE}">
<xsl:value-of select='DVMFunctions:lookupValue ("GetCaseServiceDVM/CaseType", "Type", string (/ns0:OutputParameters/ns0:GET_CASE_BY_CASENUMBER/ns0:CASETYPE ), "Description", "Unknown" )'/>

If we test the result we see that the source element with value “2” is succesfully translated to the “Claim” value.


Leave a comment

Posted by on 26-02-2015 in Oracle, OSB


Tags: ,

How to fix “Failed to invoke edit, SCAEndpoint not available” error after Oracle SOA Suite 12c upgrade

After importing an Oracle SOA project, which includes JCA Database Adapters, the result is a bit awkward. We are still able to build the project, but trying to edit the DB adapter configuration fails with this error:

Failed to invoke edit for idm_groepen: SCAEndpoint not available


After digging around in the composite and JCA file it seemed there is a difference in JCA file configuration between 11g and 12c. This is the JCA file for 11g:


<adapter-config name="idm_groepen" adapter="Database Adapter" wsdlLocation="idm_groepen.wsdl"

This is the JCA config for a 12c generated DB adapter on our composite:


<adapter-config name="idm_groepen" adapter="db" wsdlLocation="idm_groepen.wsdl"

After manually editing all our imported JCA files the problem is fixed:


Hope it helps!!!

Leave a comment

Posted by on 05-02-2015 in Oracle, SOA Suite


Tags: , ,

Using the Database Adapter in Oracle Service Bus 12c


Since the Oracle Service Bus is particularly good in handling high amounts of (small) requests very, very quickly it’s a perfect solution for entity/atomic services. In Oracle Fusion Middleware 11g the solution chosen to decouple a database was often using an Oracle SOA Suite 11g project with JCA and Mediator. However if you had specific requirements beyond basis mapping the Mediator component had it’s limits, and in the worst case you would need to extend the project with a BPEL process. From a developers perspective this is the “easy” solution since both the JCA component and Mediator are configured in JDeveloper 11g. And, the alternative, using JCA with OSB this would mean that you have to import the JCA configuration from JDeveloper 11g into your OEPE 11g. Which means more work. However my personal opinion is, that the SOA/Mediator choice is a “bloated” result for such a simple atomic service implementation. The OSB is much more suitable for atomic/entity services and SOA/BPEL should be used for orchestration purposes.

Lucky for us in Oracle Fusion Middleware 12c the development of simple atomic services to decouple a database in Oracle Service Bus 12c is less work due to tthe fact all features of OFMW are available to the developer in one IDE..


Getting Started

In this blogpost we will explain how to create an Oracle Service Bus 12c project that can act as a simple atomic service that can decouple your database.
Since a best practice is to NOT implement SQL code (INSERT, SELECT, UPDATE, etc) in your Middleware component we will use a simple PL/SQL package to communicate with the database.

First we will create a service bus project with the name getCaseService and drag the HTTP transport on the proxy service





Then drag the Database adapter on the external services and call it getCaseDB





The result will be a Oracle Service Bus project with both the newly created HTTP proxy service and the DB business service:


Then we can go and configure the pipeline. Here is a basic overview of the final result the pipeline will look like:


In the pipleline we will need 2 transformations for the request and response pipelne. In this example we will show XSLT instead of XQuery, but both are usable. First we create an XSLT for the request  pipeline transformation:






Finally we will also need to make sure the project has the response XSLT we can use for the response pipeline:





After we finalized the project we can now deploy our atomic/entity service to the IntegratedWeblogicServer and test the new service



Posted by on 03-02-2015 in Oracle, OSB


Tags: , , ,

Patching your JDeveloper 12.1.3 with SOA Bundle Patch

The SOA(/BPM) Bundle Patch is available for download from
Just use the search on patch number ‘19707784’ and it will bring you the patch details page with the download (approx. 654MB).
The patch contains lots of runtime fixes, but also some JDeveloper 12.1.3 bugs (especially while modelling BPM 12c).

So I started patching my own JDeveloper 12.1.3 environment using the OPATCH tool.

Extract the patch, I’ll use C:\temp\p19707784_121300_Generic\19707784
This folder is called ‘patch_TOP’ in opatch terminology.

Since I use Windows as local OS you will need to First open a command prompt with Administrator rights (right-click, run as Administrator).
If we don’t use the right permissions we will get the error: Unable to lock Central Inventory. OPatch will attempt to re-lock


First we set our ORACLE_HOME to the Jdeveloper 12.1.3 folder:
SET ORACLE_HOME=C:\ORACLE\middleware_12.1.3
And make sure opatch is in our path:
SET PATH=%PATH%;C:\ORACLE\middleware_12.1.3\OPatch
We browse to the patch_top folder:
cd C:\temp\p19707784_121300_Generic\19707784
And run opatch:
opatch apply

Oracle Interim Patch Installer version
Copyright (c) 2014, Oracle Corporation. All rights reserved.
Oracle Home : C:\ORACLE\middleware_12.1.3
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version :
OUI version :
Log file location : C:\ORACLE\middleware_12.1.3\cfgtoollogs\opatch
OPatch detects the Middleware Home as &quot;C:\ORACLE\middleware_12.1.3&quot;

oracle.sysman.oii.oiii.OiiiInstallAreaControl initAreaControl
INFO: Install area Control created with access level 0
Applying interim patch '19707784' to OH 'C:\ORACLE\middleware_12.1.3'
Verifying environment and performing prerequisite checks...
Patch 19707784: Optional component(s) missing : [ oracle.integration.bpm, ] , [ oracle.mft.apache, ] , [ oracle.mft, ] , [ oracle.bpm.processspaces, ] , [ oracle.soa.workflow.wc, ]
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = 'C:\ORACLE\middleware_12.1.3')

Is the local system ready for patching? [y|n] y
User Responded with: Y
Backing up files...

Patching component oracle.bpm.addon,
Patching component oracle.rules,
Patching component oracle.bpm.plugins,
Patching component oracle.soa.mgmt,
Patching component oracle.integration.bam,
Patching component oracle.soa.common.adapters,
Patching component oracle.soacommon.plugins,
Patching component oracle.integration.soainfra,

Verifying the update...
Patch 19707784 successfully applied
Log file location: C:\ORACLE\middleware_12.1.3\cfgtoollogs\opatch

OPatch succeeded.

Leave a comment

Posted by on 21-01-2015 in Uncategorized


Tags: , , , ,

Migrating Oracle Service Bus 11g to 12c (and the XQuery 1.0 upgrade)

You can easily import an Oracle Service Bus 11g project archive (JAR) in your JDeveloper 12c SB application (File -> Import)


XQuery upgrade:

Howver, when you import your Oracle Service Bus 11g project you will most likely import XQuery transformations as well. When you look at the XQuery editor in JDeveloper 12c you will probably notice that you only have “source” mode and not a graphical editor. Besides that the XQuery files show a “04” icon.


Since the early days of AquaLogic Service Bus the company formerly known as BEA (TCFKAB) supported the W3C working draft of “XQuery 1.0 and XPath 2.0 Functions and Operators” dated 23 July 2004.
In addition TCFKAB supported a number of extension functions easy to recognize with their fn-bea prefix. Since then the world moved on and XQuery made it to version 1.0 in 2007. So now in 12c there is a way to upgrade your XQuery 2004 files to version 1.0.




The “04” icons dissapear in your project and the result will be that your XQuery files will be moved to:


Besides that, since April 2014 the XQuery 3.0 recommendations are  also available. We will probably see those in future releases of SOA/OSB.



Posted by on 03-12-2014 in Oracle, OSB


Tags: , ,

Using the For Each action in Oracle Service Bus 12c

In Oracle Service Bus 12c you can use the For-Each action to iterate multiple elements in your message.
While developing a service with For-Each functionality in Service Bus 12c I discovered that there are some subtle changes in the naming of the properties since 10g + 11g.
It took me half an hour to find out what I did wrong, documentation was not really helpful so hopefully this will spare you the trouble :)

In 11g the configuration looks like (screenshot from the OSB 11g Development Cookbook):


In 12c the configuration would look more like this:






Posted by on 02-12-2014 in OSB


Tags: , ,

Patching the Oracle Service Bus 12.1.3 unknown protocol deployment error

If you (already) created your first Oracle Service Bus 12c application/project with SOAP webservices and tried to deploy it to your IntegratedWeblogic server you might be familiar with this error: OSB-398016 Error Loading the WSDL from the repository:


Lucky for us Oracle quickly released a solution on their support website and also various blogs picked it up and posted a solution. The earliest reference I found was posted by Link. The solution to your problem was either:

  • Add felix.service.urlhandlers=false to the Init properties of OSGi frameworks bac-svnserver-osgi-framework factory implementation class
  • Remove the default server as a target for the framework

This worked like a charm and I was able to play around with my 12c Service Bus. However since it was stated that the solution could result into problems with BPM on your domain I reminded myself that I wanted to dive deeper into this when I had the time.

Google helped me out, and I discovered this information on the Apache Felix framework website.

Felix installs the URL Handlers service by default. If you do not want this service you can disable it, by setting the felix.service.urlhandlers property to false in the file. It is not recommended to disable this, but the main reason for doing so it because the URL Handlers implementation invokes methods to set the singleton factories for URL stream and content handler factories. Assuming that you want to use URL Handlers service, you must configure it if you aren’t running on the standard Sun JRE.

The URL Handlers service extends the standard Java URL stream and content handler mechanism to work in an OSGi environment. The way that built-in URL protocol and content handlers are discovered is by probing packages for the appropriate classes to handle the protocol/content. ……….. The value of these properties is a list of “|” delimited package names to be searched for protocol and content handlers, respectively. See the Java documentation for stream and content handlers for more information.

So disabling the URL handler service is not recommended and you should be able to extend the list of package names used for handling content and protocols. So after poking around the world wide web I finally discovered that Oracle already released a document on this with Doc ID 1903573.1

When attempting to run both OSB and BPM in the same domain in 12.1.3 the following error occurs during creation of a WSDL file:
The WSDL is not semantically valid: Failed to read wsdl file from url due to Unknown protocol: servicebus.

Apply Patch 18640346 and recreate the domain
add protocol to -Djava.protocol.handler.pkgs in

So either download the patch or to fix this on your local integrated domain by editing the or setStartupEnv.cmd file.
I made the choice to edit the startup files and you just find & replace the multiple entries like stated below:

Windows OLD value setStartupEnv.cmd:

set JAVA_OPTIONS=%JAVA_OPTIONS% -Djava.protocol.handler.pkgs=&quot;|oracle.fabric.common.classloaderurl.handler|oracle.fabric.common.uddiurl.handler|;

Windows NEW value setStartupEnv.cmd:

set JAVA_OPTIONS=%JAVA_OPTIONS% -Djava.protocol.handler.pkgs=&quot;|oracle.fabric.common.classloaderurl.handler|oracle.fabric.common.uddiurl.handler||;

Linux OLD value


Linux NEW value




Posted by on 07-10-2014 in Oracle, OSB


Tags: , ,


Get every new post delivered to your Inbox.

Join 372 other followers