Oracle SOA File read and Write example using Mediator and File Adapter

The main aim of this post is to show how we can use Mediator in SOA suite and how to configure file read and write adapters. This case could be useful in many cases. This is just a sample example and in real world you can design more complex scenarios using Mediator component. But this post will give you good information how to work with Mediator.

In this post we are going to read an xml file using read operation of file adapter and then we will write this to a file by using another file adapter component.

1) Create a new SOA application using JDeveloper and give name as “SampleFileReadWrite” and click next and name your project as “SampleFileReadWritePro” make sure SOA is select click next and then finish with Empty Composite Template

2) Now we are going to create two XSD files for our File Adapter. This will show how to create an XSD file in SOA. It is schema file that defines input and output of different services. In you project right click on xsd folder. Give name as “InputData” and click OK.

3) Click on the source view of your newly created file, Copy the below XML and past(override) into your InputData file.

<?xml version=”1.0″ encoding=”UTF-8″ ?>

<xsd:schema xmlns:xsd=”http://www.w3.org/2001/XMLSchema”
xmlns:nxsd=”http://xmlns.oracle.com/pcbpel/nxsd”
xmlns:tns=”http://TargetNamespace.com/readFile”
targetNamespace=”http://TargetNamespace.com/readFile”
elementFormDefault=”qualified”
attributeFormDefault=”unqualified”>
<xsd:element name=”ReadFile”>
<xsd:complexType>
<xsd:sequence>
<xsd:element name=”ReadFiles” minOccurs=”1″ maxOccurs=”unbounded”>
<xsd:complexType>
<xsd:sequence>
<xsd:element name=”FirstName” type=”xsd:string”/>
<xsd:element name=”LastName” type=”xsd:string”/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>

</xsd:schema>

4) Similarly create a another XSD file named as “OutputData” and copy below data in it.

<?xml version=”1.0″ encoding=”UTF-8″ ?>

<xsd:schema xmlns:xsd=”http://www.w3.org/2001/XMLSchema”
xmlns:nxsd=”http://xmlns.oracle.com/pcbpel/nxsd”
xmlns:tns=”http://TargetNamespace.com/readFile”
targetNamespace=”http://TargetNamespace.com/readFile”
elementFormDefault=”qualified”
attributeFormDefault=”unqualified”>
<xsd:element name=”Writefile”>
<xsd:complexType>
<xsd:sequence>
<xsd:element name=”WriteFiles” minOccurs=”1″ maxOccurs=”unbounded”>
<xsd:complexType>
<xsd:sequence>
<xsd:element name=”FName” type=”xsd:string”/>
<xsd:element name=”LName” type=”xsd:string”/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>

</xsd:schema>

5) Now click on composite.xml file to open it if its not open already. Drag and Drop a Mediator in Components pallet of composite and give name as “RouteRequest” and select “Define Interface later ” as template if not selected already.

6) Now lets configure an inbound File Adapter for file reading. Drag and Drop a File adapter Component in Exposed Services swim-lane. Give name as “ReadFileAdapter” Click Next then again next and from Operation window select “Read File” as operation type and again click next. On file directories window, give some physical path where your server reside as shown below in my case.

7) Click next to move on File Filtering window. Enter *.xml in Include files with name pattern. click next and let the polling frequency as it is i.e 1. Click next to move on Messages Window. At the end of URL field click on browse for scheme file icon. Expand project schema file and select readfile under InputData.xsd as shown below

8) Click next and finish the file adapter wizard. Now drag a wire from ReadFileAdapter to RouteRequest mediator. Your composite will look like this now

Now in next part of this post I will configure File Adapter to write in a file and then will will deploy this application on SOA server and test it.
Click to move on part 2 of this post