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.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Issue with JDBC STRUCT Object while using stored procedure template...

  • 1.  Issue with JDBC STRUCT Object while using stored procedure template...

    Posted Thu July 19, 2012 12:10 PM

    Hi,

    I have to invoke a stored procedure which accepts a JDBC STRUCT OBJECT as Input.
    As the adapter services doesn’t do internal type casting from java.lang.object to STRUCT object I tried to create a java.sql.struct object to pass as input to the adapter service but not succeeded yet.:frowning:

    I was able to invoke the stored procedure via a java service by passing the oracle.sql.Struct object in the callable statement but in this way we are not able to use the adapter services.

    Is there any java code/utility service available which I can use to create a java.sql.Struct object and pass as input to the stored procedure.

    Any suggestions/advise will be appreciated.


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Issue with JDBC STRUCT Object while using stored procedure template...

    Posted Fri July 24, 2015 06:44 PM

    We have similar issue with Stored procedure,

    IS this issue resolved?

    Did you get any Java util to convert object to java.sql.struct?


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Issue with JDBC STRUCT Object while using stored procedure template...

    Posted Sat July 25, 2015 06:48 AM

    Your JDBC adapter is lacking a fix level. What is your current installed fix level.


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB