Calling BPEL Process using Database Adapter, Automatically Invoking BPEL Process

In this post i will show how we can call BPEL Process using DB Adapter. This post is a second part of my Previous post http://technasir.blogspot.com/2013/10/polling-in-oracle-soa-database-adapter.html . I will continue from previous post. I suppose you have created DB Adapter as i did in my previous post. Your requirement could be different, but scenario could match.

1) After creating DB Adapter your composite will look like this which also have BPEL Process that you want to invoke using this DB Adapter

2) Connect this DB to Your BPEL as shown below

3) Save your composite and open your .bpel name file. Delete any old Partner link, keep your newly created Adapter as shown in below snap

4) Now connect your DB Adapter that will invoke BPEL Process to receiveInput activity and a popup will appear, create a variable and click apply and then ok

5) Your BPEL file will look like below

6) Now go back to your Composite.xml file and delete old service it will be no wired now

7) Now save your Project and Build it. You might get an error like what i got. do not worry just double click on the error and select variable that is causing this error just delete those lines as shown below

8) Now rebuild and deploy it. Should be no error this time

Now every time when any changes would happen in your polling table, your DB Adapter will invoke this BPEL Process.