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
Expand all | Collapse all

Pass Types as Input to a Stored Proc

  • 1.  Pass Types as Input to a Stored Proc

    Posted Mon September 10, 2012 05:22 PM

    Hi,

    I have a scenario where I have to pass a Table type as input to a stored procedure.
    I created a JDBC adapter - Stored procedure with signature, I see the input as an object with input field type
    as java.sql.struct.

    How do we map an input to the adapter service ?

    How do we convert the IS document so that it maps as an input to the stored procedure ?

    Thanks !!
    Raaj Pradeep


    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Pass Types as Input to a Stored Proc

    Posted Tue August 20, 2013 03:19 AM

    Hi All,

    I have same scenario, like where I have to pass a Table type as input to a stored procedure.
    I created a JDBC adapter - Stored procedure with signature, I see the input as an object with input field type
    as java.sql.struct.

    How do we map an input to the adapter service ?

    How do we convert the IS document so that it maps as an input to the stored procedure ?

    please suggest me how to achive these scenario.

    thanks Advance

    Thanks,
    Guru.


    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Pass Types as Input to a Stored Proc

    Posted Wed September 18, 2013 06:53 PM

    While wM 8 also has adapter service template to pass on Connection to a java service from the Adapter pool, its not much useful while using Types, especially Oracle Types. The DB Connection object passed is a proxy object and cannot be used within java service to register for Oracle Type. We need a OracleConnection object, which is having additional features to handle Oracle Types (VARRAY or STRUCT). So, better write a java service.

    For connection pooling, you can use any open source connection pooling mechanism, such as c3p0, dbcp or Oracle’s.


    #webMethods
    #Integration-Server-and-ESB