IBM Support

PI94863: UNABLE TO GET PROGRESS DATABASE CONNECTIONS FROM PROGRESS OPENEDGE 11 DATASOURCE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • What is happening is that WebSphere makes a call to
    getNetworkTimeout() during connection initialization, which is
    an optional method per the JDBC specification.  According to the
    JDBC specification, a SQLFeatureNotSupportedException is
    supposed to be thrown if a JDBC driver does not support that
    optional method.  However, the OpenEdge JDBC Driver is throwing
    a generic SQLException.  Our code attempts to handle this
    incorrect behavior by checking if the SQLException thrown
    includes the text "not supported", however in this case the text
    used is "not support".  We can make an improvement to WebSphere
    so that it will handle this JDBC driver behavior.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server                                      *
    *                  using Progress DataDirect JDBC Driver       *
    ****************************************************************
    * PROBLEM DESCRIPTION: When using the Progress DataDirect JDBC *
    *                      Driver a SQLException is thrown when    *
    *                      obtaining a connection.                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When using the Progress DataDirect JDBC Driver a SQLException is
    thrown indicating "This driver does not support the
    'getNetworkTimeout' and 'setNetworkTimeout' methods." This is
    because WebSphere makes a call to getNetworkTimeout during
    connection initialization and expects the JDBC specification
    defined SQLFeatureNotSupportedException to be thrown if a driver
    does not support the optional getNetworkTimeout method.
    Note that it is possible that a similar exception could be seen
    with other JDBC drivers, which should also be resolved by the
    fix
    in this APAR.
    

Problem conclusion

  • An improvement was made in WebSphere Application Server to handl
    the exception thrown by the Progress DataDirect JDBC Driver.
    
    The fix for this APAR is currently targeted for inclusion in
    fix pack 9.0.0.8 for WebSphere Application Server and 18.0.0.2 f
    WebSphere Liberty.  Please refer to the Recommended Updates
    page for delivery information:
    http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI94863

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    900

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-03-08

  • Closed date

    2018-03-28

  • Last modified date

    2018-03-28

  • 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

  • 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":"900","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
18 October 2021