Connect to the default derby database of SOA 12c

Once you have installed SOA Suite 12c demo version you might have noticed that it doesn't need you to run the RCU and create schemas. In SOA 12c everything is already taken care of with the installation.

Infact a dummy derby database is created and all the schemas are created when we install SOA 12c.

The connect string to this default derby database is

jdbc:derby://localhost:1527/dummy;ServerName=localhost;databaseName=dummy

So if you want to connect to the derby database just in case you wanted to inquire few thing from back end you need to do the following things

First of all since it is a derby database you need to import the derby driver class

you can download the derby driver class from the following location

http://db.apache.org/derby/releases/release-10.10.2.0.cgi

Once you have downloaded the driver

Extract and save it in a local folder.

Now follow the steps below


Create a new Database connection




Provide the details for the database

CONN_HOSTNAME as localhost

CONN_JDBCPORT as 1527

Database Name is dummy

Driver Class is org.apache.derby.jdbc.ClientDriver

and Then in the library click on search icon and import the library for derby client as shown

Once you pointed it to the correct library

Test the connection.




Once connection is successful expand the list of object in the db connection to validate all the artifacts