Integration

Hello Everybody,

Requirement
------------
I am doing DB Adapter polling in OSB.I have a db adapter which polls order table whenever there is a record with status='N'.The OSB component is on single node of Weblogic Server.

1.The db adapter picks the order data with status='N' in the proxy service
2.It transforms to webservice xsd
3.Invokes a webservice.
4.The webservice returns acknowledgement number.
5.The order table should be updated with status 'Z' and attribute1=acknowledgement number

OSB Service Design
--------------------
1.Proxy service calls business service to poll the order table
2.Converts the payload to the xsd format required by target
3.Invokes the webservice on target
4.Receives acknowledgement number
5.calls a plsql procedure which updates all the records within this batch with the acknowledgement number and status='Z'

My configurations in db adapter
----------------------------------
Logical delete option in db adapter.

Unread Value :'N'
Read Value : 'A'

Polling frequency : 300 seconds

no of databse rows per XML document : 10

Database rows per transaction : 10


Issue
--------
1.My process after getting the acknowledgement number it updates the status with Z and attribute1=acknowledgement number.At the of this transaction I am seeing that the status is being updated by

the adapter to 'A' based on read value.I want the read value only to be updated initially but as soon as my OSB process picks it for further processing it should not update again.How can i prevent

the status from getting updated to 'A'.

2.I have 40 records in order table.Per the database rows per transaction it should process 10 records at a time and for each batch of 10 i should get one acknowledgement number.Instead i see that

all the 40 records are updated with the same acknowledgement number.Kindly help as to how I can resolve this situation.

Thanks & Regards,
Radha