Poll database using DB adapter in Oracle Service Bus
1) Right click on the left swim lane and configure the DB adapter as a polling adapter
Select the Poll for New or Changed Records in a Table option
Select the source(USERS) table
Select the Update a Field in the Table(Logical delete). This option allows you to update the Field after the record has been picked up.
Enter the below details:
a) Logical Delete Field: Select Field based on you want to poll. In our case field name is ISACTIVE
b) Read Value: Enter the value that you want to update after read the row
c) Unread Value: Enter the value, on which you want to select record
d) Reserved Value: Enter the value that would be updated once the record picked up,let’s say ‘L’
Click Next and Finish.
Let’s start with message flow(Pipeline)
Create a XSLT transformation to transform the poll result to insert result
Create a pipeline, Right click on the middle swim lane and insert pipeline
Message flow will look like
a) Location: body
b) Value: select XSLT
c) Replace Option: Replace node content
Run the application and check the Users_DUMP table. This table must have 2 records as Users table had two records with INACTIVE column having value ‘Y’. Once the poll completed, you can see INACTIVE flag become to ‘N’ in Users table.