1) How to Configure DB Adapter for Polling
2) How to Invoke BPEL Process using DB Adapter, or Automatically
Steps to configure polling in SOA DB Adapter
1) Drag and Drop a Database Adapter in Exposed services, left side, on Service name window give Service Name
2) Create a Connection to your DB and give JNDI name that you have set in your Weblogic
3) In Select Operation Type window select “Poll for new or changed records in a table”
4) In Next Window Import tables and select table on which you want polling
5) In next Window check Primary key for detail see below snap
6) Click next and you will reach on attribute filtering window. check if you want any other attribute. i only have one. Read detail for more info
7) Click next and choose what you want after reading, i am writing on file, that are present on my server
8) Click next you have to give location of your file
9) On next screen set your polling frequency and i set 10
10) Click next, next and finish it on Finish window your Adapter now configured
In next tutorial i will show how you could invoked BPEL Process using this DB adapter
Here is the link of next Part
http://technasir.blogspot.com/2013/10/calling-bpel-process-using-database.html