PQ75806: PORTNUMBER SHOULD NOT BE A REQUIRED PARAMETER WHEN CONFIGURE THEDATA SOURCE USING CONNECT JDBC DRIVER

APAR status
Closed as program error.

Error description
SQL Server 2000 has the concept of Named Instance
The DataDirect Connect JDBC Driver 2.2 and 3.x support the SQL
Server Named Instance by specifying Named Instance in the
serverName attribute (e.g. MyHost\MyInstance) and leave blank
for the portNumber.
.
The data source configuration (both WAS 4.0.x and 5.0.x) has
portNumber as a required parameter. That means, it can't be
blank.
.
The portNumber should be an optional parameter for the data
source using Connect JDBC Driver. This allows the Named Instance
to be specified in the serverName and leave blank for portNumber
Local fix
Put bogus port number in portNumber attribute to bypass the
configuration validation (but this is misleading).
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users, who use  *
*                 Connection pooling and Merant drivers        *
*                 for data access.                             *
****************************************************************
* PROBLEM DESCRIPTION: The portNumber field was required       *
*                      when configuring a DataSource using     *
*                      Merant or DataDirect drivers.           *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Requiring the port number was no longer necessary.
Problem conclusion
The restriction of the portNumber being a required
parameter on the dataSource was removed.
Temporary fix Comments
APAR information
APAR number PQ75806
Reported component name WEBSPHERE AE NT
Reported component ID 5630A3601
Reported release 00A
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2003-06-30
Closed date 2003-06-30
Last modified date 2003-06-30

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

APAR is sysrouted TO one or more of the following:

Modules/Macros
JDBC          

Publications Referenced

Fix information

Applicable component levels
R003 PSY    UP
R00A PSY    UP
R00H PSY    UP
R00I PSY    UP
R00P PSY    UP
R00S PSY    UP
R00W PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 00A
Software edition:
Reference #: PQ75806
IBM Group: Software Group
Modified date: Jun 30, 2003