webMethods

webMethods

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
Back to discussions
Expand all | Collapse all

Issue with JDBC Adapter part from 6.5 release and Oracle 10G RAC.

  • 1.  Issue with JDBC Adapter part from 6.5 release and Oracle 10G RAC.

    Posted Mon May 29, 2006 11:55 AM

    Hello All,

    We are facing issue with JDBC Adapter part from 6.5 release and Oracle 10G RAC.
    We made following test:

    StartTranasaction
    Insert
    Kill the node on which transaction is running.
    Commit - > No eception was thrown and no data are inserted in DB.
    Rollback in case of exception.

    The issue is: When we kill the node commit is executed without errors and we can not identify, should we repeat transaction or not. The service end without erros.
    The most interesting is when we perform for example select after execution of service, we receive exception “Transaction must rollback”.
    Could anybody help with this strange behavior of JDBC Adapter?
    And why connection is open on insert statement but not on Start Transaction statement.
    There is something wrong here.

    Bets Regards,
    Krasimir Zlatev


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


  • 2.  RE: Issue with JDBC Adapter part from 6.5 release and Oracle 10G RAC.

    Posted Tue May 30, 2006 05:06 PM

    Hi Krasimir,
    Please search the past discussions on this forum. There are lots of threads discussing the JDBC Adapter Transaction related issues. Will give you good insight.

    Regards,
    Bhawesh.


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


Related Content