EXPLORE ORACLE FUSION MIDDLEWARE

There are scenarios when we want to complete commit or complete rollback. This is known as transaction handling. To demonstrate this scenario I am taking following use case. Use Case : Read a file and insert data into Header and Line tables. Data must be inserted into both the tables or it should be complete roll back in case of any exception. Lets start the use case : 1. Drag a file adapter in the Exposed Services. Configure it to read a file from Local directory. For more details to configure a FTP adapter, please go through my previous block : http://exploreofm.blogspot.in/2015/09/soa-12c-how-to-read-file-using-file.html 2. Configure two database adapters to insert data into header and line tables. 3. Create a BPEL process and wire it to the FTP adapter and database adapter. After wiring it your composite should look like as below : 4. Add invoke activity and other assign activity to complete BPEL process. Deploy the service to em co...

In this post I will explain how to read, delete, and archive a file from any location. This post will also explain reading content of file in 12c and configuration of NXSD (Native Format Builder). This post can be applicable for SOA 11g also. File Adapter Configuration : Drag File Adapter to Exposed Services section : Enter file adapter JNDI Name File Adapter have multiple operations read, write, sync and chunked read operations. Here we are using read operation. Enter file source and archive location. If you don't want to archive any file, uncheck the Archive check box. Specify File name pattern to read files based on any pattern. Set Polling frequency. Polling frequency is the interval in which adapter will read the file from the particular location. Now we need to define an NXSD schema, to convert the file data to XML f...