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.  JDBC Adapter - Transaction Types

    Posted Tue August 22, 2006 04:09 PM

    Hi All,

    Could anyone tell me when to use following transaction type and when not to use?

    NO_Transaction
    Local_Transaction
    XA_Transaction

    Tha nks
    kali


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 2.  RE: JDBC Adapter - Transaction Types

    Posted Tue August 22, 2006 04:40 PM

    Kali,

    From Pg 15 of JDBC 6.0.3 users guide…

    ***********
    [FONT=PalatinoLinotype-Roman][SIZE=2]

    NO_TRANSACTION : The connection provides no transaction control over the operations being performed. That is, the connection automatically commits (Auto Commit) all operations.

    LOCAL_TRANSACTION : With this transaction type, all of the operations on the same connection in one transaction boundary will be committed or rolled back together. A transaction boundary means the scope of the transaction, from the beginning to the end of a transaction. It can be in one adapter service, one flow service, one Java service, or several steps in a flow service.[/size][/font]

    [FONT=PalatinoLinotype-Roman][SIZE=2]XA_TRANSACTION : This transaction type allows the connection to support two-phase transactions executed across multiple databases. In one transaction boundary, all of the operations on multiple connections will be committed or rolled back together. A transaction boundary means the scope of the transaction, from the beginning to the end of a transaction. It can be in one adapter service, one flow service, one Java service, or several steps in a flow service
    ****************

    Hope this helps.

    Anitha.

    [/size][/font]


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 3.  RE: JDBC Adapter - Transaction Types

    Posted Tue August 22, 2006 09:21 PM

    Kali,
    Basically if you use LOCAL_TRANSACTION you will have to use the starttransaction, commitTransaction and rollbackTransaction. Whereas if you use NO_TRANSACTION its going to do an auto-commit after each of your SQLs(Inserts, updates and deletes especially). XA_TRANSACTION as it says is used for two-phase commit.
    Hope this helps a bit more.
    Bala


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: JDBC Adapter - Transaction Types

    Posted Wed August 23, 2006 07:39 AM

    Hi Anitha & Bala,

    Thanks for your explanation.

    -kali


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 5.  RE: JDBC Adapter - Transaction Types

    Posted Fri September 08, 2006 12:28 AM

    Hi,

    Thanks from my side too…

    J


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


Related Content