• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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

 

45

 

Assign:

Dvm: look up 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/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 Name space

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

 

WSDL : (Concrete WSDL’s)

  1. These WSDL ‘s must have same “target namespace” required

 

Definition:

Improve the performance by reducing the PL’s

  1. There WSDL’s must have same payload required

46

 

Note:

  1. Create add 2 num , mul 2 num projects
  2. Add 2 num , mul 2 num should take same name space
Aspired to become an Oracle SOA?
Explore the post to discover the know-hows on Oracle SOA Training.

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>

 

Assign 2:

<end point reference XMLS = “TNS”>

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

</end point reference>

 

  1. 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

 

  1. Correlation set:

To maintain state ful session by using the “correlation ID”

Project 2 correlation set à BPEL 2 synchronous

 

47

 

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 :

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

 

Transform :

Receive1 2 output

 

DB –poll adapter:

48

 

 

[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 shows 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)

  1. It’s a light weight component , it does n’t contains activities except transform and assign
  2. Validation (schema tran) à (XSD and element validation)
  3. Routing Rules [PL’s]
  4. Filter[conditions]
  5. Transform
  6. Mediator directly can call adapters

 

Note:

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

Project 2 mediator _add 2 num à synchronus

Composite name, composite mediator

49

 

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 :

  1. <WSDL: part name = “request “ element = “INPL: single string”/>
  2. <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 Indepth knowledge on Oracle SOA, click on below

Summary
Review Date
Reviewed Item
What is DVM(Static value mapping) in Oracle SOA
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on What is DVM(Static value mapping) in Oracle SOA"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.