Soa12c – Creating DB Connection in JDeveloper to JavaDB

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)

Java DB Status and Port
Java DB Status and Port

Create a new “Database Connection”  from Resources tab of JDeveloper. Fill in highlighted value to get connected to JavaDB.

Java DB Connection Details
Java DB Connection Details

Open “SQL Worksheet” from “Databases” window and execute any sql query to verify the connection.

JavaDBSQLQuery
JavaDBSQLQuery

Leave a Reply

Your email address will not be published. Required fields are marked *