Oracle SOA 11G-Working With BPEL

We are going to see,how to implement Hello World in BPEL Process.It is a basic tutorial for all those willing to learn SOA.Without any more words, lets start with the tutorial.Let me just give you a brief overview of BPEL process.We will create one synchronus BPEL process that will accept string as an input and will return the same string in output concatenated with "Hello".So lets start desigining our BPEL process step by step.

Prerequisite for this tutorial1. Oracle JDeveloper
2. Oracle SOA Suite
3. Weblogic Server

Oracle SOA 11G-File Adapter Tutorial

File adapter is basically used to read,write files locally on your server.
There are mainly 4 operations in FILE adpater namely:

• READ: its an inboun operation that reads a file from given dir path
• WRITE: outbound operation to write files to a location specified under directory path
• SYNCHRONUS READ: outbound operation used to read a file in middle of the process
• LIST FILE: outbound operation to list all the files in a given directory

SOA 11G-Composite Sensors

Composite sensors provide a method for implementing trackable fields on messages. Composite sensors enable you to perform the following tasks:

•     Monitor incoming and outgoing messages.
•     Specify composite sensor details in the search utility of the Instances page of a SOA composite application in Oracle Enterprise Manager Fusion Middleware Control. This action enables you to locate a particular instance.
•     Publish JMS data computed from incoming and outgoing messages.
•     Track composite instances initiated through business event subscriptions.

SOA 11G-Getting and Setting JMS Header Properties

Sometimes there is requirement where you are required to set some JMS header values and then send the jms message to the client or consumer may interact with you via jms queue and sends some user defined properties in the JMS header.In BPEL 11G, we can easily set or retreive these values.

Oracle SOA 11G-Database Adapter Tutorial

Oracle JCA adapter for DB enables a BPEL process to communicate with Oracle databases or third party databases through JDBC. The Oracle Database Adapter service is defined within a BPEL process partner link by using the Adapter Configuration Wizard of Oracle BPEL Process Manager (Oracle BPEL PM).

There are number of operations avilable that you can perform with DB adapter namely :

• Call a Stored Procedure or Function :Select this option if you want the service to execute a stored procedure or function.
• 
  Perform an Operation on a Table: Select this option for outbound operations. You can select Insert or Update, Insert Only, Update Only, Delete, Select, or any combination of the six. 
• 
  Poll for New or Changed Records in a Table:  Select this option for an inbound operation (that is, an operation that is associated with a Receive activity). This operation type polls a specified table and returns for processing any new rows that are added. You can also specify the polling frequency.
• Execute Pure SQL: Useful when dealing with arbitrarily complex statements, aggregate queries (result is not row-based), and XMLType columns.

Adding nodes and creating variables in XSL - Oracle SOA 11G

Today I am gonna write about,how to use summation function in XSL and how to create a cariable and use it in your xsl. Actually,there was a requirement in our project,which was like adding some values of some fields in the input and based upon the sum we required to pass some value to the target system.So, to accomplish this we used sum function, that is available in xslt.

I will be demonstrating it taking one example.Suppose we have some fields that are coming in the input such as A,B,C and we need to add all these values and see whether its sum is greater than zero or less than zero.If the sum is greater than 0, we will pass say "pass" and if its other way around we will pass say "fail" to the target system.I have create a sample BPEL process for this usecase.Process is very simple: it is exposed as webservice and taking input from the client and after doing aforesaid transformation and logic will publish the message in jms Queue.I will just explain the XSL part.

SOA 11G-Polling using Sequencing File in DB Adapter

I will be explaining today steps to create a polling DB adapter based on sequencing file.Most commonly used After Read "Logical Delete" strategy, I have explained already in one of my previous posts.So, I will just explain configuration required for sequencing file polling DB adapter. Remaining configuration, how to configure DB adapter , please refer to my post on DB adapter tutorial.