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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only

  • 1.  JDBC Adapter: stored procedures + cursors

    Posted 10/14/02 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 10/15/02 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 10/15/02 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 09/04/06 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