SOA 11g Tutorial: Prepare and Setup

This is part of the Oracle SOA11g hands on tutorials.

* Book Download Page

* Download sample zip file SOA11g_GettingStarted.zip, unzip, and copy po folder to c:\

C:\po\SQL
-- Create soademo user
sqlpus system
SQL> @create_soademo_user.sql
 
-- Create creditrating table
sqlplus soademo/soademo
SQL> @create_creditrating_table.sql

* Login WebLogic console, e.g. http://localhost:7001/console
* Go to Services -> messaging -> JMS Modules
* Click SOAJMSModule

* Click New
* Select Queue, click Next
– Enter JMS Destination Properties and click Next.

Name:demoFulfillmentQueue
JNDI name: jms/demoFulfillmentQueue

– Select

Subdeployments: SOASubDeployment
JMS Servers: SOAJMSServer

and click Finish.

* In SOAJMSModule Summary of Resources screen
* Click New
* Select Connection Factory and click Next
– Enter

Name: demoCF
JNDI Name: jms/demoCF

* Click Next
* Click Finish

* Create a new JMSAdapter deployment plan directory on SOA domain host machine

mkdir /opt/oracle/Middleware/home_11gr1/Oracle_SOA1/soa/JMSPlan

* Click navigation tree: Deployments
* Click JmsAdapter
* Click on tabs: Configuration -> Outbound Connection Pools
* Click New
* Select: oracle.tip.adapter.jms.IJmsConnectionFactory
* Enter
JNDI Name: eis/Queue/demo
* Click Finish
* Enter deployment plan path
Path: /opt/oracle/Middleware/home_11gr1/Oracle_SOA1/soa/JMSPlan/Plan.xml
* Click OK

* Click on Configuration tab
* Expand: oracle.tip.adapter.jms.IJmsConnectionFactory
* Click: eis/Queue/demo
* Enter:
ConnectionFactoryLocation: jms/demoCF
* Hit Enter key
* Click Save

* Click on “Deployments” from left hand side Domain Structure panel
* Select checkbox for JmsAdapter
* Click Update
* Verify deployment plan file location
* Click Next, Finish

* Go to Services -> Data Sources
* Click New -> Generic Datasource
* Enter

Name: soademoDatabase
JNDI Name: jdbc/soademoDatabase
Database Type: Oracle

and click Next.
* Select
Database Driver: Oracle’s Driver (Thin XA) for Service connections; Verions:9.0.1 and later
and click Next.
* Click Next on Transaction Options screen.
* Enter Database connection properties:

Database Name: <strong>orcl.world</strong>
Host Name: localhost
Port: 1521
Database User Name: soademo
Password: soademo

and click Next.
* Click Test Configuration. A green font message ‘Connection test succeeded’ should show up on the top of the screen.
* Click Next.
* On Select Targets screen, check soa_server1 and click Finish.

* Create plan directory on host machine

mkdir /opt/oracle/Middleware/home_11gr1/Oracle_SOA1/soa/DBPlan

* Click Deployments on tree menu
* Click DBAdapter
* Click Configuration -> Outbound Connection Pools
* Click New
* Select javax.resource.cci.ConnectionFactory and click Next
* Enter
JNDI Name: eis/DB/soademoDatabase
and click Finish.
* Enter
Path: /opt/oracle/Middleware/home_11gr1/Oracle_SOA1/soa/DBPlan/Plan.xml
* Click OK

* Click on Configuration tab -> Outbound Connection Pools
* Expand javax.resource.cci.ConnectionFactory
* Click eis/DB/soademoDatabase name
* Click Properties tab and enter
xADataSourceName: jdbc/soademoDatabase
* Hit Enter key
* Click Save button.

* Click Deployments on left panel
* Select checkbox for DbAdapter
* Click Update
* Select
Redeploy this application using the following deployment files
* Verify
Deployment plan path: /opt/oracle/Middleware/home_11gr1/Oracle_SOA1/soa/DBPlan/Plan.xml
* Click Finish