Skip to Content
avatar image
Former Member

regarding Transaction Isolation Level

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 25, 2009 at 03:25 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 25, 2009 at 03:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded