IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Lock Types in Tamino

    Posted Wed July 18, 2001 09:00 AM

    Hi,

    How the locktypes are being implemented in Tamino ? I mean [ Column level, Record level, Table level ]. Ofcourse there is no concept of Column, Record and Table in Tamino.
    How the concurrent updations of a single Node are managed in Tamino ?

    Enlight me,

    Thanks,
    N.V.Sairam.


    #API-Management
    #webMethods
    #Tamino


  • 2.  RE: Lock Types in Tamino

    Posted Thu July 19, 2001 04:21 PM

    Hi,

    1. Currently there is no update of a single node possible (not implemented yet). Only documents can be updated.

    2. For Locktypes and how to use locking have
    a look at the documentation, e.g.

    Tamino 2.3.1.1/help/xprog/xprspstr.htm#xprstran

    The _isolation Parameter
    The _isolation parameter specifies in what way two or more applications can access the same data simultaneously. If one session is currently accessing data from the database and a second session attempts to access or modify the same data, the setting of the _isolation parameter for each of the sessions determines whether access is possible for the second session.

    The _lockwait Parameter
    The _lockwait parameter specifies which action to take if data is currently not accessible because another transaction has used the _isolation parameter to restrict access to the data. This parameter can have the following values:

    Best regards,


    Jan Harmsen
    Technology Consultant
    Partner Engineering


    #webMethods
    #Tamino
    #API-Management


  • 3.  RE: Lock Types in Tamino

    Posted Mon July 23, 2001 05:08 AM

    Hi Jan,

    thanks for the detailed answer.

    regards,
    n.v.Sairam

    [This message was edited by N.V.Sairam on 23 Jul 2001 at 03:46.]


    #Tamino
    #webMethods
    #API-Management


  • 4.  RE: Lock Types in Tamino

    Posted Tue November 20, 2001 07:40 PM

    So does this mean - Tamino support “document-level locking” ?

    Or, does it lock the entire collection ? Or, it depends on what operation is been performed ?

    –naren


    #Tamino
    #webMethods
    #API-Management


  • 5.  RE: Lock Types in Tamino

    Posted Mon November 26, 2001 10:16 AM

    Hi,

    “document-level-locking” is what is done.

    This also means that a query with no “where”-clause (i.e. ?_xql=doctype) issued in a transaction with isolation=protected locks every single document in this doctype.

    Whereas ?_xql=doctype[node/node=“HelloWorld”] would only lock documents for which the query expression node/node=“HelloWorld” is true. SELECT FOR UPDATE is the sql-ish expression for this behaviour, I think.

    Best regards, Andreas


    #Tamino
    #webMethods
    #API-Management