apps-infra

    Forum Stats

  • 3,873,691 Users
  • 2,266,628 Discussions
  • 7,911,601 Comments

Discussions

ESB database table polling without deleting the record

martin777
martin777 Member Posts: 11
edited Oct 12, 2008 5:11PM in SOA Suite Discusssions
Is it possible to use DB Adapter to poll a database table for new records without actually deleting them in the source table? I think it's not a problem to use a trigger to insert a record to temp table (which will be used for polling) whenever there is an INSERT into the source table, but still...
Tagged:

Answers

  • Yes there is 2 ways, logical delete where you specify a field in that table you are polling that determins the status of the row, e.g. R = read, P = Processing, N = New

    If this isn't a option as this would mean customising the table you can use sequencing tables that use a field in the table as a sequence, e.g. id, or data-time. This sequencing table stores the last row read.

    Have a look at the samples in the $SOA_HOME/bpel/samples/tutorials/122.DBAdapter

    This has examples of all methods.

    cheers
    James
    James Taylor-Oracle
This discussion has been closed.
apps-infra