Lab 5-Lifecycle - Entries for cut + paste for command line

Set environment:

export PATH=/u01/app/oracle/fmw/12.2/oracle_common/modules/org.apache.ant_1.9.2/bin/:$PATH

export JAVA_HOME=/usr/java/jdk1.8.0_51

Find Ant packages:

cd /u01/app/oracle/fmw/12.2/soa/bin

Compile from command line:

ant -f ant-sca-package.xml -DcompositeDir=/u02/oracle/developer/mywork/POProcessing/POProcessing/SOA -DcompositeName=POProcessing -Drevision=3 -Dsca.application.home=/u02/oracle/developer/mywork/POProcessing

Deploy from command line:

ant -f ant-sca-deploy.xml -DserverURL=http://localhost:8001 -DsarLocation=/u02/oracle/developer/mywork/POProcessing/POProcessing/SOA/deploy/sca_POProcessing_rev3.jar -Doverwrite=true -DforceDefault=true -Dconfigplan=/u02/oracle/developer/mywork/POProcessing/POProcessing/POProcessing_dev_cfgplan.xml

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!