Connecting to SOA 12c Quickstart install embedded Java database

I couldn't find this information in the docs or any public sources via Google search, so I thought I would share it with the world.

Anyone reading this is likely already aware that Oracle SOA Suite 12c has a developer install called the Quickstart, which provides a JDeveloper dev environment with a bundled run-time server embedded in JDev for dev/test purposes. This server includes a Java database, which SOA Suite uses, but which also has pre-installed schemas for the end-to-end order processing tutorial. If you want to use this embedded Java database to create database adapters, or anything else requiring a database, you will need connection information - which is hard to find.

In any case, the answer is that if you are creating a database adapter for a SOA composite or Service Bus service, you use:

• Note: first, you must start the embedded WebLogic Server Instance in JDev
• Connection type: Java DB (Derby)
• *No* username or password
• Driver Class: org.apache.derby.jdbc.ClientDriver
• Hostname: localhost
• Database name: soainfra
• JDBC Port: 1527

And if you are then perusing the database tables using the database adapter, to find the tutorial tables:

• Select schema: SOAINFRA
• Query against %
• You will see all the tables begin with E2E, as in "E2E_1201_PAYMENT_INFO" for the credit card table

See screenshots below and enjoy!