PI34376: Unable to specify empty port number for DataDirect Connect for J DBC and Microsoft SQL Server JDBC Driver

8.5.5.5: WebSphere Application Server V8.5.5 Fix Pack 5
8.5.5.6: WebSphere Application Server V8.5.5 Fix Pack 6
8.5.5.7: WebSphere Application Server V8.5.5 Fix Pack 7
8.5.5.8: WebSphere Application Server V8.5.5 Fix Pack 8
8.5.5.9: WebSphere Application Server V8.5.5 Fix Pack 9
8.5.5.10: WebSphere Application Server V8.5.5 Fix Pack 10
8.5.5.11: WebSphere Application Server V8.5.5 Fix Pack 11
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.15: WebSphere Application Server V8.5.5 Fix Pack 15
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.17: WebSphere Application Server V8.5.5 Fix Pack 17
8.5.5.20: WebSphere Application Server V8.5.5.20
8.5.5.18: WebSphere Application Server V8.5.5 Fix Pack 18
8.5.5.19: WebSphere Application Server V8.5.5 Fix Pack 19
8.5.5.16: WebSphere Application Server V8.5.5 Fix Pack 16
8.5.5.21: WebSphere Application Server V8.5.5.21

APAR status

• Closed as program error.

Error description

• When using properties.datadirect.sqlserver and
  properties.microsoft.sqlserver, the port number is defaulted
  to 1433, making it difficult to avoid specifying a value,
  which is necessary when using SQL Server named instances.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server Liberty Profile with Microsoft SQL   *
  *                  Server database                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Unable to specify empty port number for *
  *                      DataDirect Connect for JDBC and         *
  *                      Microsoft SQL Server JDBC Driver        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using properties.datadirect.sqlserver and
  properties.microsoft.sqlserver, the port number is defaulted to
  1433, making it difficult to avoid specifying a value, which is
  necessary when using SQL Server named instances.
  

Problem conclusion

• Removed the default value for portNumber from both
  properties.datadirect.sqlserver and
  properties.microsoft.sqlserver configuration elements so that
  the JDBC driver has the opportunity to default the value.
  
  The fix for this APAR is currently targeted for inclusion in fix
  pack 8.5.5.5.  Please refer to the Recommended Updates page for
  delivery information:
  http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
  

Temporary fix

• Specify a value of 0 for portNumber, which the JDBC driver might
  interpret as meaning it should fill in its own default.
  Alternately, use the generic properties configuration element
  rather than properties.datadirect.sqlserver or
  properties.microsoft.sqlserver, in which case the portNumber is
  not defaulted to anything by the application server.
  

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

  WAS LIBERTY COR

• Fixed component ID

  5725L2900

Applicable component levels

• R855 PSY

     UP