mobileNavlogo
headerlogo

What is DVM(Static value mapping) in Oracle SOA

Blog Author

Tekslate

Published Date

16th October, 2020

Ratings

Views

624

  • Share this blog :

 

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: 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/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

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 :

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

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

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .

Related Blogs

Write For Us