ESB database table polling without deleting the record

martin777

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...

James Taylor-Oracle

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