Monday, July 28, 2014

SOA 12c - Connecting to Java Derby Database

Oracle SOA 12c uses Java Derby Database by default. The derby server will automatically start once we start the Integratedweblogicserver. Hence, in order to create a database connection to Derby server, your Java Derby server must be up and running.

Refer to this post on how to start Integratedweblogicserver. 

Follow the below steps to create Java Derby server connection for the SOAINFRA schema.

Open Jdeveloper and click on Resources tab and navigate to the databases as shown.
Now select the connection Type as Java DB(Derby) and browse for the appropriate JDBC driver as shown
Test the connection with the details as shown below and click ok
Thus the database connection to the Java Derby DB is now created. It will be shown in the Resources tab under IDE Connections.

No comments:

Post a Comment