Update query not working in sender JDBC adapter

[Former Member]

Hi,

Am fetching data from SQL server database table.

Select query is working fine but UPDATE query is not updating the records whichever read.

Tried checking with the database team and provided my update query which they executed onto database system and executed perfectly.

Not sure why the same update query is not updating database table through JDBC adapter.

Please provide any inputs on this.

[justin_santhanam]

How does your select statement looks like. Are you using the same Where clauses?

>>>The UPDATE statement must alter exactly those data records that have been selected by the SELECT statement. You must use the same WHERE clause in the UPDATE and the SELECT statements.

See below under Defining Processing Parameters, SQL Statement for Query, and SQL Statement for Update.

Thank you,

Justin.

[former_member186851]

Hello Ajmal,

Can you please post the query being used?.

[Former Member]

UPDATE table SET PIREAD = 1 WHERE PIREAD = 0

[former_member186851]

In the advanced properties,try changing the transaction_isolation Level to repeatable_read or serializable and check.

[Former Member]

Sritharan,Tried that option but still not updating the table field.

[Former Member]

did you check the Audit log of the sender channel. it will show you the query details. Kindly Share the log details