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

generic JdbcAdapter for stored procedures

  • 1.  generic JdbcAdapter for stored procedures

    Posted 08/26/13 07:41 AM

    Hi wmusers!

    Maybe someone cane help me here. I have a oracle databse with almost 50 stored procedures. Every procedure have the same one IN and one OUT variable (in VARCHAR, out VARCHAR). I don’t want to make 50 adapters, so here comes the question. Is this possible to make a generic jdbc adapter with procedure name as a parameter?

    I can’t change procedures - one in var, one out var.


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


  • 2.  RE: generic JdbcAdapter for stored procedures

    Posted 08/26/13 01:00 PM

    one workaround I can think of:
    create another SP:
    with two in, one out
    the 2nd IN parameter is the sp name

    this new SP will decide which SP to call based on the 2nd in parameter


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