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.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Default transaction isolation level in JDBC Adapter

  • 1.  Default transaction isolation level in JDBC Adapter

    Posted Tue June 30, 2015 03:34 PM

    Can any one please let me know what is the default transaction isolation level in JDBC adapter ? Where can we find it ?

    Any help will be much appreciated.


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


  • 2.  RE: Default transaction isolation level in JDBC Adapter

    Posted Wed July 01, 2015 04:15 AM

    Do you have any technical issues during your implementation and just note that this information will be provided in the SAG docs. If you have any technical issues or concerns then you may use this community site.

    The type of isolation levels supported by the adapter depends on the database that you
    are connecting to. The commonly used isolation levels are TRANSACTION_READ_UNCOMMITTED, TRANSACTION_READ_COMMITTED, TRANSACTION_REPEATABLE_READ, and TRANSACTION_SERIALIZABLE. The JDBC Adapter supports all the isolation level settings supported by your database.

    The isolation level settings can be specified in the Other Properties field of the Connection
    Configuration screen.

    For oracle, default isolation level settings is read_commited.


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