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

9.0.0.8: WebSphere Application Server traditional V9.0 Fix Pack 8
9.0.0.9: WebSphere Application Server traditional V9.0 Fix Pack 9
9.0.0.10: WebSphere Application Server traditional V9.0 Fix Pack 10
9.0.0.11: WebSphere Application Server traditional V9.0 Fix Pack 11
9.0.5.0: WebSphere Application Server traditional Version 9.0.5 Refresh Pack
9.0.5.1: WebSphere Application Server traditional Version 9.0.5 Fix Pack 1
9.0.5.2: WebSphere Application Server traditional Version 9.0.5 Fix Pack 2
9.0.5.3: WebSphere Application Server traditional Version 9.0.5 Fix Pack 3
9.0.5.4: WebSphere Application Server traditional Version 9.0.5 Fix Pack 4
9.0.5.5: WebSphere Application Server traditional Version 9.0.5 Fix Pack 5
WebSphere Application Server traditional 9.0.5.6
9.0.5.7: WebSphere Application Server traditional Version 9.0.5 Fix Pack 7
9.0.5.8: WebSphere Application Server traditional Version 9.0.5.8
9.0.5.9: WebSphere Application Server traditional Version 9.0.5.9
9.0.5.10: WebSphere Application Server traditional Version 9.0.5.10
9.0.5.11: WebSphere Application Server traditional Version 9.0.5.11

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 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