PQ52454: AFTER PQ51500 WEBSPHERE FAILS TO CREATE A DATASOURCE WHEN BRINGING UP THE ADMIN SERVER ON SYBASE

 A fix is available

PQ52454, 4.0.1: Cumulative Connection Pooling fix



APAR status
Closed as program error.

Error description
Fail to create datasource when bringing up admin server in
Sybase 12 version on NT platform.
SMTL0026E: Failure to create a data source: java.sql.
SQLException: JZ0S3: The inherited method getConnection()
cannot be used in this subclass.
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage
  .java:459)
at com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource.
.
Ref: CMVC defect 111816  111811
Local fix Problem summary
****************************************************************
* USERS AFFECTED: All users of WebSphere Application Server    *
*                 with Sybase or Informix databases.           *
****************************************************************
* PROBLEM DESCRIPTION: After 
PQ51500, Sybase and Informix      *
*                      databases didn't work properly.         *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Defects 111811 and 111816 were fixed in this APAR.  The
description for 111811 is:
Clear Parameter ignored first parameter set. Which resulted in
an exception like java.sql.SQLException: Unsufficient number
of parameter were set before execution{1, 2}. Parameter 0 was
not cleared.
The description for 111816 is:
Pass user & password when getting connection for
PortabilityLayer; handle Sybase class heirarchy where
javax.sql.DataSource#getConnection cannot be called.
Problem conclusion
These problems were corrected by changing code in:
com/ibm/ejs/cm/cache/CachedStatement.java
com/ibm/ejs/cm/portability/SybasePortabilityLayer.java
com/ibm/ejs/cm/portability/PortabilityLayerImpl.java
com/ibm/ejs/cm/portability/SybasePortabilityLayer.java
Temporary fix Comments
APAR information
APAR number PQ52454
Reported component name WEBSPHERE AE NT
Reported component ID 5630A2201
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2001-09-14
Closed date 2001-09-21
Last modified date 2001-10-05

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros

SRLS

Fix information
Fixed component name WEBSPHERE AE NT
Fixed component ID 5630A2201

Applicable component levels
R400 PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ52454
IBM Group: Software Group
Modified date: Oct 5, 2001