What is DVM(Static value mapping) in Oracle SOA

Create table:

Country code	Country name
IN	INDIA
ENG	ENGLAND
US	UNITED STATES

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

Modify the table:

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

   

Assign:

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

Modify the country name:

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

open  open DVM 

select table nameopen 

edit -select whatever we want to change click  

It shows 

Country code:   IN

Country name: INDIA

OK   Commit  yes -  

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

Example:

i/p	o/p	i/p	o/p
IN	GREAT INDIA	IN	INDIA

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

 

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.

XSD:

i/p  n1 ,n2  int

o/p result à int

switch:

Label : n1>n2

Condition: number (n1) > number (n2)  

Assign 1:

i/p  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  correlation set à BPEL  synchronous

   

Note:

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

XSD:

i/p  sid  int

o/p   eid  int

ename   string

eloc string  

create table :

ID	name	Loc
101	Ram	HYD
102	SAI	WRNGL
103	TEJA	HYD1

Transform :

Receive1  output

DB –poll adapter:

   

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

Select – property, ok    

Select – property, ok   

Select – property1, ok    

Select – correlation set1, ok    

Yes    apply          ok  

Receive 1: (double click)

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

/(edit)     click

/(edit)     click

/(edit)     click

/(edit)     click  

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

Query Ctrl + space ,      

After then it will show Ok         

Select – property1 – employee 243, ok  

Select – property1, ok   

Select – property1, ok    

Select – correlation set1, ok   

apply ok       

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 mediator _add 2 nums à synchronous

Composite name, composite 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  result

Mediator: ( file poll – DB insert)    

File poll:

Poll native  schema normal format

DB_ insert:

Create table ,   insert only

Double click on mediator:

Transform:

File poll DB_ insert(mapper)

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

• Oracle SOA ATA (Application Integration architecture)
• How to work with FTP(File transfer protocol) in Oracle SOA
• Oracle SOA Interview Questions & Answers
• Oracle SOA Admin Interview Questions
• Oracle SOA Tutorials