JDBC Sender Adapter

[Former Member]

Hello,

We have configured a Sender JDBC Adapter to Poll data from the DB2 tables. It is working fine and both the select and the update queries written are also getting properly executed and are changing the status of the flag from Y to N once read from database.

In the communication channel ->

select * from <table> where flag = 'N'.

update <table> set flag = 'Y' where flag = 'N'.

But I have one doubt after executing the select query some new data comes into the table of status flag 'N"., then will this unselected data will also be updated to 'Y' .

The question is while we do a select and update from XI on the DB table and at the same time there is an insert happening into the table from the other end how will the adpater behave in this case.Will it result in missing of some records during next select/update transaction from XI..

Thanks for your help

Srinivas

[Former Member · Accepted solution]

Hi Srinivas,

Check this link

http://help.sap.com/saphelp_nwpi71/helpdata/EN/7e/5df96381ec72468a00815dd80f8b63/content.htm

> The question is while we do a select and update from XI on the DB table and at the same time there is an insert happening into >the table from the other end how will the adpater behave in this case.Will it result in missing of some records during next >select/update transaction from XI..

When you are inserting the data to the database then that record is locked by the databse. so you don't get partial records. Once the record is completely inserted to the database then only database allows (releases the lock) the insert/update options to that row.

Regards

Ramesh

[Former Member]

Thanks

[Former Member]

Hi Srinivas,

U need to select Transaction isolation level as serilizable.

Last week itself I searched for this solution for my project.

Regards,

Manisha

[Former Member]

Hi,

Please refere below thread.

[]

You can use "serializable" option in advanced mode to update exactly same records which are picked by select query.

Warm Regards,

Gouri

[Former Member]

You need to select Transaction isolation level as serilizable

so that only selected records for that transaction will be updated ...and the records inserted in b/n the transaction operation will be ignored...

HTH

Rajesh