OSB : DB Adapter-Poll - Update sequencing table using Oracle Service Bus 12c

 In this section, will explain only the DB adapter section how to update sequencing table operation using OSB (only the operation design part) .In the DB adapter option, select "Update a sequencing table" instead of "Delete the rows that were read" option in the below link and follow the steps mentiond here. For detailed step on creating proxy,pipeline,xquery,business service , please refer
https://gnanaprakasamsolutionsblog.blogspot.com/2018/02/osb-db-adapter-poll-delete-physical.html

 
  

 
 
 
 
 









The sequence gets updated with the sequence picked


Directly inserting sequence 12 with status Y in source table so that i gets skipped from polling and there wont be an entry in sequence table




Sequence table with latest picked sequence from source table

Target table with all records picked from source

Comments

Post a Comment

Popular posts from this blog

Configure, Modify, Rename,Delete a listener for Oracle 11g database

Image
  Steps to configure listener When a client like SQL Developer, toad etc. wants to establish a connection to an Oracle Server, it usually first contacts the listener . The listener then creates a foreground process ( dedicated mode ) or attaches the request to an existing foreground process ( shared mode ). The client then directly communicates with that foreground process . A listener can accept requests for more than one instance. Likewise, more than one listener can accept requests for the same instance (load balancing). 1.         Open terminal and go to the bin folder under ORACLE_HOME  cd /u01/app/oracle/product/11.2.0/dbhome_1/bin ./netca 2.         Since there are no existing listeners we will get only add listener as option. Click on Add option and click next. 3.         Provide the name for the listener (Eg. ORCL, DB11G etc.) 4.         Select the protocol in which the listener will be listening for the connections.
Read more

Oracle DB:Oracle 12C DB installation Error -Failed to access the temporary location

Image
While installing Oracle 12 database in Windows 7, an error "Failed to access the temporary location" occurs. Error: Cause - Failed to access the temporary location.  Action - Ensure that the current user has required permissions to access the temporary location.  Additional Information:  - Framework setup check failed on all the nodes  - Cause: Cause Of Problem Not Available  - Action: User Action Not Available Summary of the failed nodes <>- Version of exectask could not be retrieved from node “<>”  - Cause: Cause Of Problem Not Available  - Action: User Action Not Available Solution:  To get rid of this issue, add share in "Computer Management" 1. In Run (Win symbol+R) , type  compmgmt.msc 2. Under Shared Folders, Shares 3. Right click, Click on "New Share" 4. Click Next 5. Provide "C:\" in the Folder path and  click Next 6. Click Yes to continue  7. Provider "C$" fo
Read more

OSB : DB Adapter-Poll - Delete Logical Records using Oracle Service Bus 12c

Image
In this section, we will see how to use the Logical delete of records from table for polling tables from database.  Note: For creating connection factory, datasource, deployment , DBAdapter for poll and merge please verify my blog page  OSB : DB Adapter-Poll - Delete Physical Records using Oracle Service Bus 12c Here will explain only the essence of logical delete and how the data is picked and processed.  VERSION USED:  SOA SUITE 12C - 12.2.1.3 DB  12C - 12.2.0.1.0 SOURCE SCHEMA - SCOTT  SOURCE TABLE - EMP_UI TARGET SCHEMA - TGT  TARGET TABLE - EMP_UI_TGT Create table and insert records . In this option we have to add one more column for performing the logical delete just by updating the values.  Here we are making logical delete on column "STATUS" by changing poll value from "N" to "Y"  Physically the data will be available in the database but the process wont pick it as the condition mentioned for the pr
Read more