yes u can create a BPEL Process in which use a database adapter to poll on the particular table and then invoke some process as pe your requirement
Every BPEL Process is deployes on the app server as a webservice
I have exact this requirement. Can you point me to any such online example that will POLL my table for (New and Updated) records and then be able to provide it AS a service for those records.
Meaning, if I give process WSDL to third party, they will really get those updated / new records as in response. step by step example will be good.
You can do this by coming up with 2 projects.
Project 1: polls for the new records, in your table of interest,and write to a temp table.
Project 2: (exposed as a Web service, takes an empty input). Whenever called will read all the records from the temp table and return them as output of the Web service. Further, delete all the records in the temp table after reading from it.
Mark the posting appropriately, as "helpful", "correct answer", if your issue is solved.
easiest way i think is :
- create new composite
- create new polling db adapter
- create new bpel process based on wsdl and then use the wsdl of the just created polling db adaper and check "Expose as soap service".
in that case both will have the same service interface
I don't think that this is basically possible.
A dbadapter polls a table, then can post it to a BPEL process.
As suggested by another guy here, I think you can post from the BPEL process to a temp table and read from the temp table from another BPEL Process.
1. [table]-->[dbadapter polling] --> [BPEL Process 1] --> [temp table]
2. Client (SOAPUI...) --> [BPEL Process 2] --> [temp table]
Edited by: oracledigger on Jan 29, 2013 2:35 PM