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

  • 1.  JDBC adapter and Sybase stored procedure

    Posted Fri April 26, 2002 04:52 PM

    Has anyone tried the JDBC adapter to invoke a sybase stored proc (doing select, update inside)? All the stored procs we have in sybase are in the unchained mode but once the JDBC adapter is trying to call a stored proc it will receive an exception “may be run only in unchained transaction mode…” For varies reasons, we can’t change the mode to anymore. And the problem I know because the JDBC adapter is doing auto-commit inside which does not work well with unchained stored proc. Has anyone encountered something like that? Is this a JDBC adapter bug or Sybase bug?

    Thanks.


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


  • 2.  RE: JDBC adapter and Sybase stored procedure

    Posted Mon January 26, 2004 09:49 AM

    I am having this same issue, did you ever resolve this? If so, how?

    Thanks


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


  • 3.  RE: JDBC adapter and Sybase stored procedure

    Posted Fri February 06, 2004 05:56 AM

    If you cannot set the procs to unchained mode then you will need to set the JDBC adapter to NO_TRANSACTION.


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


  • 4.  RE: JDBC adapter and Sybase stored procedure

    Posted Tue May 31, 2005 01:57 PM

    We changed the Stored Procedure Mode to Any.


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


Related Content