webMethods

webMethods

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

Need jdbc SQL query of the stored procedure invoke

  • 1.  Need jdbc SQL query of the stored procedure invoke

    Posted Mon September 12, 2022 07:24 AM

    What product/components do you use and which version/fix level are you on?

    webMethods 10.5

    Is your question related to the free trial, or to a production (customer) instance?

    production instance

    What are you trying to achieve? Please describe it in detail.

    We are making stored procedure jdbc calls and sometimes it fails at the database side.
    So, we want the actualy sql query which is hitting the db with the actual parameters.

    We have tried increasing the adapter logging level to trace. If we use dynamic adapter service, then we are able to see the query in the logs but not with stored procedure. Also, tried spy option in the jdbc pool, no luck. Any help/suggestion would be appreciated.

    Do you get any error messages? Please provide a full error message screenshot and log file.

    Have you installed all the latest fixes for the products and systems you are using?

    yes


    #Adapters-and-E-Standards
    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


Related Content