Soa 12.2.1 New Feature – End to End JSON and Javascript Example

Output from REST GET Query

SOA 12.2.1 provides support for end-to-end JSON and Javascript. We don’t have do internal mapping between XML and JSON as in 12.1.3. As part of this post, let us implement a simple REST service to demonstrate this new feature – End to End JSON with Javascript. Let us create a very… Read moreSoa 12.2.1 New Feature – End to End JSON and Javascript Example

Get value from Coherence Cache using Coherence Adapter

Test Result

This post is in continuation to Add Coherence node to Soa 12c’s integrated weblogic coherence cluster post.  As part of earlier post, we created another coherence node , added a value to out-of-box adapter-local cache. As part of this blog, we will see how to get value from coherence cache using coherence… Read moreGet value from Coherence Cache using Coherence Adapter

Add Coherence node to Soa 12c’s integrated weblogic coherence cluster

Standalone Coherence Node

Let us see how to add coherence node to Soa 12c’s integrated Weblogic coherence cluster. We will put value in out-of-box “adapter-local” cache from the added node and access that value from a SOA Composite using Coherence Adapter. We will use the out-of-box cache config  from Soa 12c’s Coherence Adapter. It… Read moreAdd Coherence node to Soa 12c’s integrated weblogic coherence cluster

Soa 12.2.1 – RCU Installation Error – Error Creating PL/SQL Object – MDS Internal Common

Error in DB

While Installing schemas using RCU utility for the latest SOA 12.2.1 release, following error occurred irrespective of Database version (10g XE, 11g XE, 11gR2, 12c). After Ignoring the error, rest of RCU installation went through fine. On logging in with MDS schema user account (<prefix>_MDS), JDev shows following error These… Read moreSoa 12.2.1 – RCU Installation Error – Error Creating PL/SQL Object – MDS Internal Common

Soa 12.2.1 Feature – Patching Running instance of Composites

BPEL Process

Soa 12.2.1 was released recently. Let us see how to implement one of the new feature of this release – Patching Running instances of composites. With this feature, we can make selective modifications to running composites’ base code, create a patch using JDeveloper. Using WLST commands, we can apply the patch to server…. Read moreSoa 12.2.1 Feature – Patching Running instance of Composites

Finding instances using wildcard search on title field in SOAINFRA schema

Query Sca_Flow_Instance table

This post is about finding instances using wildcard search by querying SOAINFRA schema. Edited on 6th Feb: Wild Card search in EM on instance title works in 11g and 12c . Tested with 11.1.1.7.8 and 12.2.1. Specific composite instance can be located in EM using  composite instance’s title and composite sensor’s… Read moreFinding instances using wildcard search on title field in SOAINFRA schema

Soa12c – Creating DB Connection in JDeveloper to JavaDB

Java DB Connection Details

In 11g, we need to have Oracle DB(minimum 10g XE version) for SOA Dehydration store. However, SOA 12c Quick Installation comes with a Java based Database called JavaDB. Let us see how to create a connection to Java DB and execute a query. Start JDeveloper’s Integrated Weblogic Server. This should automatically start… Read moreSoa12c – Creating DB Connection in JDeveloper to JavaDB

Soa12c – How to locate a composite instance using title and sensors in EM

Searching by Sensors

In a high-volume environment, it is not easy to go and find a  particular composite instance which processed a particular Order Id. We will see in this blog two ways in which we can locate a particular composite instance in Enterprise Manager. To locate a composite instance using wild card search see Wild… Read moreSoa12c – How to locate a composite instance using title and sensors in EM

Soa12c – Extension function error: Method not found ‘setFlowInstanceTitle’

setFlowInstanceTitle

We need to use  the new  function setFlowInstanceTitle to set  composite instance title in 12c environment. If JDeveloper doesn’t show this function or gives a warning that it is not able to find the function, we need to patch SOA (including JDeveloper) with latest bundle patch. If we deploy the composite,… Read moreSoa12c – Extension function error: Method not found ‘setFlowInstanceTitle’

12c – How to apply patch to SOA Suite using OPatch in Windows Environment

Check Orcle Inventory

Let us see how to apply Oracle Patches in Windows environment using OPatch. In this post, let us apply latest Bundle patch for SOA12c Before we patch Download latest Bundle Patch from Oracle Support Web Site. As of this post,  the filename is p21885138_121300_Generic.zip(SOA 12.1.3.0.4 Bundle Patch) If needed, download latest OPatch software from Oracle… Read more12c – How to apply patch to SOA Suite using OPatch in Windows Environment