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

jdbc connector error,after restart the connector,everything works fine

  • 1.  jdbc connector error,after restart the connector,everything works fine

    Posted Tue February 21, 2006 05:33 AM

    error log: can’t execute sql: “in sert into …”…
    ora 02067 error: transaction or savepoint rollback required

    when I execute sql in developer, i still met this error

    And then, i restart the jdbc connector, everything went well.

    And the wm service just inserts a table and calls a stored procedure in oracle.
    This service has been running really well for several month.
    The procedure has a automonoums transaction, i don’t know whether this mattered.

    I’ve found the oracle error is about distributed transaction, but in my procedure ,there is no operation on remote database.

    Any comments or guides?
    Thanks a lot
    Nancy


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


Related Content