regarding Transaction Isolation Level

[Former Member]

We talk about query and update constent problem again. even I don't take it as problem.

I can see this in SAP notes or SAP help:

JDBC Sender Adapter...

· The UPDATE statement must alter exactly those data records that have been selected by the SELECT statement. You can ensure this is the case by using an identical WHERE clause. (See Processing Parameters, SQL Statement for Query, and SQL Statement for Update below).

· Processing can only be performed correctly when the Transaction Isolation Level is set to repeatable_read or serializable.

If I set transaction isolation level as default, then how can I make sure ' default' is repeatable_read or serializable?

Our DB is Informix.

[Former Member]

Hey

Please go through the below blog and see if it helps

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

Thanks

Aamir

[Former Member]

for updates "Serializable " is advisable, you have to select in JDBC receiver -CC ,it is not default.