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

JDBC Adapter Query performance

  • 1.  JDBC Adapter Query performance

    Posted Wed September 24, 2003 08:40 PM

    It seems some SQL statements are getting “hard parsed” per execution. A trace file shows the number of execution is equal to the number of hard parses.

    Any ideas?

    Thanks in advance,
    Daniel

    Details:
    The integration is selecting and inserting mutiple records during a single activation (sub).
    Using the out of the box Configured Operations.
    JDBC Adapter 4.6 on IBM AIX
    Oracle 9i on IBM AIX.


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


Related Content