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