IBM Support

PI88123: JPA FAILURE WHEN DEFINING DATA SOURCE CUSTOM PROPERTY JDBCTIMINGTHRESHOLD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 1. Following patching the development environment to WebSphere
    8.5.5.12, was testing new troubleshooting feature using custom
    property
    JDBCTimingThreshold as discussed here:  https://www.ibm.
    com/support/knowledgecenter/en/SSAW57_8.5.5/com.ibm.websphere.nd
    .iseries.doc/ae/rtrb_jdbclong.html
    
    2.  When setting the property as a persistent setting to Oracle
    data sources, receive a warning: DSRA8020E: Warning: The
    property 'JDBCTimingThreshold' does not exist on the DataSource
    class oracle.jdbc.pool.OracleConnectionPoolDataSource.
    
    3.  Also within one application, using the property results in
    application query errors due to org.apache.openjpa.persistence.
    ArgumentException which is caused by java.util.
    UnknownFormatConversionException: Conversion = '''.
    
    [9/29/17 10:45:36:084 CDT] 000000b7 WSRdbManagedC 3   JDBCTiming
    threadTime:
                                     49095168
    [9/29/17 10:45:36:084 CDT] 000000b7 WSJdbcPrepare <
    executeQuery Exit
                                     RuntimeException
    
    java.util.UnknownFormatConversionException: Conversion = '''
        at java.util.Formatter.checkText(Formatter.java:2559)
        at java.util.Formatter.parse(Formatter.java:2545)
        at java.util.Formatter.format(Formatter.java:2481)
        at java.util.Formatter.format(Formatter.java:2435)
        at java.lang.String.format(String.java:2124)
        at
    com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.jdbcTiming(W
    SRdbMana
    gedConnectionImpl.java:6279)
        at
    com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(W
    SJdbcPre
    paredStatement.java:744)
        at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQ
    uery(Del
    egatingPreparedStatement.java:270)
    ...
    
    
    4.  Clearing the property removes this application error.
    

Local fix

  • Remove custom property
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Special characters in SQL Statements    *
    *                      could cause JDBC Timing to throw        *
    *                      UnknownFormatConversionException.       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Using special characters, such as '%', in SQL Statements
    caused JDBC Timing to throw
    java.util.UnknownFormatConversionException: Conversion = '''
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI88123

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-10-02

  • Closed date

    2017-10-12

  • Last modified date

    2017-10-12

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

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

Fix information

  • Fixed component name

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

  • R850 PSY

       UP

  • R900 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"850","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
18 October 2021