Create table:

Country codeCountry name
ININDIA
ENGENGLAND
USUNITED STATES

DVM: lookup value(‘country .DVM’, ’ country code’, i/p, ‘country name,’’ ’)  

Modify the table:

http://local host:8001/SOA/COMPOSER

  45  

Assign:

Dvm: lookup values (‘country.dvm’,’country code’, input,’country name’, ‘ ’)

Modify the country name:

http://local host:9001/SOA/composes

open 2 open DVM 2

select table name2open 2

edit -select whatever we want to change click2  

It shows 

Country code:   IN 2

Country name: INDIA 2

OK  2 Commit 2 yes -2  

Note:  when your deploy again it shows previous o/p.

Example:

i/po/pi/po/p
INGREAT INDIAININDIA

Dynamic partner link:

WS _ addressing.XSD

<End point Reference XMLS =  “TNS”><Address> WSDL </Address></end point reference>

TNS:

In WS – addressing.XSD

Target Namespace

(ex: “http://schemas.XML SOAP .org/WS/2003/03/addressing”)  

WSDL :

(Concrete WSDL’s)

  • These WSDL‘s must have the same “target namespace” required

Definition:

  • Improve the performance by reducing the PL’s
  • There WSDL’s must have the same payload required

DVM  

Note:

  • Create add 2 num , mul 2 num projects
  • Add 2 num , mul 2 num should take same name space

Inclined to build a profession as Oracle SOA Developer? 
Then here is the blog post on Oracle SOA Training Online.

XSD:

i/p 2 n1 ,n2 2 int

o/p2 result à int

switch:

Label : n1>n2

Condition: number (n1) > number (n2)  

Assign 1:

i/p 2 invoke i/p  

Assign 2:

<end point reference XMLS = “TNS”>

<Address> add 2 num concrete WSDL </address>

</end point reference>    

  • X – Ref (cross Reference)

Dynamic object value mapping

Note: DVM à maps only one column (look up value)

X – Ref :

  • Maps all columns
  • Look up X Ref
  • Populate XRef row
  • Mark for Delete

 

  • Correlation set:

To maintain the stateful session by using the “correlation ID”

Project 2 correlation set à BPEL 2 synchronous

  Correlation set  

Note:

  • Receive and receive  1 correlation set.
  • Only “property Aliases” different remaining all same.

XSD:

i/p 2 sid  2int

o/p 2  eid 2 int

ename  2 string

eloc 2string  

create table :

IDnameLoc
101RamHYD
102SAIWRNGL
103TEJAHYD1

Transform :

Receive1 2 output

DB –poll adapter:

DB-poll adapter    

[message types/partner links/BPEL process –client /BPEL process1.WSDL /message types/BPEL process1 request message/part – payload ] 2select Query Ctrl + space ,  2 After then it will shows 2Client ;process /client :sID2Ok    

Select – property, ok    2

Select – property, ok   2

Select – property1, ok    2

Select – correlation set1, ok    2

Yes   2 apply     2     ok  

Receive 1: (double click)

+  --> select – correlation set , initiate (NO)

/(edit)    2 click

/(edit)     2click

/(edit)    2 click

/(edit)    2 click  

[message types/partner links/DB poll /DB poll WSDL /message types/employee 243/ part – Employee 243 ] 2select

Query Ctrl + space ,    2  

After then it will show Ok    2     

Select – property1 – employee 243, ok  2

Select – property1, ok   2

Select – property1, ok    2

Select – correlation set1, ok   2

apply 2ok       

Mediator (11g)/ ESB (10g)

  • It’s a lightweight component, it doesn’t contain activities except transform and assign
  • Validation (schema tran) à (XSD and element validation)
  • Routing Rules [PL’s]
  • Filter[conditions]
  • Transform
  • Mediator directly can call adapters

Note:

  • The client asking send the data source to the destination based on conditions, then we will use the mediator
  • Orchestration services will not do in a mediator, that’s why we are going to use “BPEL process’
  • Mediator 3 times faster then BPEL process

Project 2 mediator _add 2 nums à synchronous

Composite name, composite mediator

Mediator  

XSD:

<element name = “Addition”>

<complex type>

<sequence>

<element name = “n1”type = “int”/>

<element name = “n2”type = “int”/>

</sequence>

</complex type>

</element>

<element name = “Response”>

<complex type>

<sequence>

<element name = “Result”type = “int”/>

</sequence>

</complex type>

</element>

</schema>  

WSDL :

  • <WSDL: part name = “request “ element = “INPL: single string”/>
  • <WSDL:part name =”reply” element = “inpl:”>

Double click on mediator:

Click

Number (n1) > number (n2)

Transform :

N1 – i/p1

N2 – i/p2

Synchronous reply :

Sum 2 result

Mediator: ( file poll – DB insert)    

File poll:

Poll 2native  schema normal format

DB_ insert:

Create table , 2  insert only

Double click on mediator:

Transform:

File poll 2DB_ insert(mapper)

For In-depth knowledge on Oracle SOA, click on below