Oracle SOA : Exposing data using Web Service

Hi folks! Welcome to my new post on Oracle SOA.
 
This post explains the use of Mediator as a component to expose the data through a Web Service Adapter to outside world, received from DB Adapter.
[The WSDL URL obtained later, can be consumed in an ADF Application. Check out this post]
To start with, I have the following resources handy
ü  Jdeveloper IDE  (11.1.1.7.0) + SOA Extensions

ü  Oracle DB XE 11G (Up & Running!)

ü  WL Servers 10.3.6 (Up & Running!)

ü  Internet Explorer 10 (10.0.9200.16384)


Here it goes,

Ø  Create a SOA Application with Empty Composite as below.


 


Ø  Drag & drop a “Database Adapter” from component palette to the External References swim lane as pictured below.
 
 

Ø  Click “Next” in the popup invoked to configure the DB adapter.
 

 

Ø  Input a Service Name, choose a DB Connection.
Ø  Remember the JNDI name & configure the same in the Admin Console as well as update the DB Adapter Plan. [ For more details on how to configure, check this site http://smconsultants.in/2012/08/working-with-the-database-adapter-in-oracle-soa-suite-11g.html ]
Ø  Choose “Select” operation and import the “Employee” Table.
Ø  Don’t bother about dependencies and move on to create a parameter upon which, it will be queried.
 
 
 
Ø  Configure the “Web Service” Adapter by dragging & dropping on the “Exposed Services” swim lane as given below. 
 
Ø  Name the Service, generate the WSDL from schema – choose a “Synchronous” Interface for type, add Input & Output part names. 
 

Ø  Click “OK” to return back to Web Service Configuration popup, again press “OK” to finish it.
 

Ø  Now add a “Mediator” component to components swim lane as shown below.

 
Ø  Name the Mediator & choose “Define Interface Later” Template and click “OK”.
Ø  Wire the WS to Mediator & Mediator to the DB Adapter to look similar as below.  
Ø  Double click the Mediator to configure the mapping of “Request” & “Response” in mplan.
 
 
 
 

[Note: Expand the tree node and map individual attributes. Values are populated only for the mapped attributes.]
Ø  Click on Save & deploy the Application Server.

Ø  If the Build is successful, check the EM console for the deployed application.

Ø  Select the application & click on “Test” to test the Service.

Ø  Enter a value for “empID” parameter & invoke the Test Web Service button to see the response.
 
 

Ø  Finally the required output is achieved. [Note down the WSDL URL for client accessing] 

Comments

Post a Comment

Popular posts from this blog

Oracle ADF: Add a Favicon to Page, Page Template

Image
A favicon, also known as a web site icon, tab icon or bookmark icon, most commonly 16×16 pixels, associated with a particular Web site or Web page. Resources used -           Jdeveloper IDE   (11.1.2.3.0) -           Internet Explorer 10 (10.0.9200.16384) So, how to implement this in Oracle ADF? It’s simple, take a breath there! Ø   Create an ADF Application Ø   Place the favicon image (e.g. used in POC – flower_blue.ico) in the Web Content Root location as depicted in the image below. (FaviconViewController\public_html). For supported image file formats check http://en.wikipedia.org/wiki/Favicon#File_format_support Ø   Set “ smallIconSource ” value equal to “ /flower_blue.ico   ” under Appearance of af:document tag.     Image - 1 Ø   Set the Java EE Application web context root to “ / ” as...
Read more

Oracle ADF : Dynamic Regions

Image
A good web design should consider the following aspects Page boot-up/ load speed Visually attractive appeal Quicker navigation The first two aspects largely deal with the amount of  picturesque content, styling & UI approach taken. In this post, I am going to deal with "In-Page" Navigation. The above approach helps to keep the end user engaged still being on the same page. So, the question here is, how to achieve it? Oracle ADF provides Regions & Dynamic regions to achieve this. A region is a section of the page that renders, so if we are ought to achieve dynamic updation of region, we need to implement Dynamic Regions - an ADF region where the task flow binding dynamically determines the value of its taskFlowId attribute at runtime. Hope you got the theory, let's check it out... Create an adf application (For the demo sake, I have developed based on static content, not related to any data bound components). Considering the work space s...
Read more

Oracle ADF : Working with Parameters

Image
Parameters accept and store values and can be very helpful in ADF applications. There are many types of parameters as visualized below. To demonstrate the above scenario let’s develop a ADF application, Scenario: Lets have 3 buttons on a page & on press of each button renders different page fragments by passing the parameters as depicted in above pic. Ø   Create a JSPX page – “Index.jspx” with no bindings, add 3 buttons with action listeners respectively with each action listener having a unique value, say first button has the following value   #{‘a’} stored to #{requestScope.ClickRec}, i.e this translates to ClickRec of requestScope variable storing a value – ‘a’ on clicking first button in laymen’s terms. Ø   As the components on page is not bound to any data controls, no data bindings is created dynamically, so update this by right clicking on the page & create Page Definition and accept the defaults. Ø   Naviga...
Read more