IBM Support

IT16123: XPATH ERROR WITH MULTIPLE QUOTE SYMBOLS IN LWJDBC ADAPTER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • User reports an XPath error when trying to use XPath to build
    an SQL query that contains the quote (") character. It appears
    that this might only happen when there are multiple parameters
    being built with XPath at run time. If there is only one, the
    quotes appear to work correctly.
    
    The error message received is similar to this:
    Unable to get/create XPath object from cache with XPath value
    of ""select "PRODUCT_LABEL" from SI_VERSION WHERE SI_COMMENTS =
    ?"".  The system log may have further information.  Search for
    "XPathCacheLoader.load" to find more detailed information.
    

Local fix

  • Example:
    STRRTC - 502733
    JPM / JJB
    Circumvention: None
    

Problem summary

  • Users Affected:
    All
    
    Problem Description:
    User reports an XPath error when trying to use XPath to build
    an SQL query that contains the quote (") character. It appears
    that this might only happen when there are multiple parameters
    being built with XPath at run time. If there is only one, the
    quotes appear to work correctly.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix has been provided.
    
    Delivered in:
    5020603
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT16123

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    525

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-14

  • Closed date

    2016-12-15

  • Last modified date

    2016-12-19

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R526 PSY

       UP

[{"Line of Business":{"code":"LOB02","label":"AI Applications"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5"}]

Document Information

Modified date:
26 September 2021