JDBC Sender

[Former Member]

Hi,

I am using jdbc adapter to pick records where status is 'N' and after picking it updates as 'C'.

Unfortunately, it picked the same set of records twice.

I believe if XI cant commit it will rollback and wont process any messages.

Will it there be any issues in XI or the sender system has triggered it twice.

Please share light on this.

Am using the update statement and select statement in the sender adapter itself.

[Former Member · Accepted solution]

Select the check box for Advanced attributes and select "Serializable" option

[GabrielSagaya]

select query=Select * from tablename where status ='c'

update query=update tablename set status='N' where status 'c'.

also Check [Advanced Mode]

Number of Retries... : 2

Transaction Isolation Level: serializable

Activate the checkbox [Database Auto-Commit...]

Activate the checkbox [Disconnect from Database ...]

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

[Former Member]

Hi Anandha,

I understand that a record had status N and then after reading JDBC adapter updates it as C.

Once it is updated as C, that record will not be picked up again, unless you manually update it again to N. In which case, it will again be changed to C.

There will be no issues with the system except that the receiving system will have duplicate records.

Please explain your scenario a bit more, if it is not clear.

-Regards,

Shamly.