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 JavaDB (aka Apache Derby)
Create a new “Database Connection” from Resources tab of JDeveloper. Fill in highlighted value to get connected to JavaDB.
Open “SQL Worksheet” from “Databases” window and execute any sql query to verify the connection.