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: stored procedures + cursors

    Posted Mon October 14, 2002 01:17 AM

    Hi…

    Are there any problems in using stored procedures which return cursors when using the JDBC adapter? I’ve got a webMethods consultant who said that he had seen problems with it before. What if the stored procedures returns many rows?


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


  • 2.  RE: JDBC Adapter: stored procedures + cursors

    Posted Tue October 15, 2002 03:29 AM

    Hi,

    you can’t use JDBC adapter to call stored procedures which return cursors… with Oracle adapter it should work. The reason is that cursors are not defined in the JDBC standard (for the moment). hope this help.
    Frederic.


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


  • 3.  RE: JDBC Adapter: stored procedures + cursors

    Posted Tue October 15, 2002 08:28 PM

    Hi…Thanks for your reply. Yeap, that helps a lot! Have a nice day!


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


  • 4.  RE: JDBC Adapter: stored procedures + cursors

    Posted Mon September 04, 2006 01:03 AM

    Currently i am using JDBC Adapter: stored procedures + cursors. cursors are working fine in 6.1 version with jdbc adapters also.


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


Related Content