PQ59880: DO NOT DROP CONNECTION POOL ON SYBASE JZ006 ERROR.

APAR status
Closed as program error.

Error description
Sybase uses JZ006 as a generic error for both fatal and non-
fatal errors. When WebSphere gets this error, we dump the
connection pool.  Sybase is going to add to this error msg, when
non-fatal, through the set next exception method, a java io
exception. This apar is to differentiate between the fatal and
non-fatal JZ006 errors, and only dump the connection pool for
fatal errors.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: All WebSphere Application Server users of    *
*                 Sybase as the Database.                      *
****************************************************************
* PROBLEM DESCRIPTION: The user would see WebSphere hang on    *
*                      a Statement Query Timeout.              *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Sybase uses JZ006 as a generic error for both fatal and non-
fatal errors.  When WebSphere gets this error, the connection
pool is dumped.  Sybase is going to add to this error message,
when non-fatal, through the set next exception method, a java
SQLException.  On the SetQueryTimeout() method is
specifically where we would get the non-fatal version of
the SQLException.
Problem conclusion
The portability layers was modified to work with Sybase
EBF 10105, which is required with this APAR.   WebSphere is
now are able to distinguish between the fatal and
non-Fatal JZ006 SQLExceptions.
Temporary fix Comments
APAR information
APAR number PQ59880
Reported component name WEBSPHERE AE SO
Reported component ID 5630A2202
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-04-08
Closed date 2002-04-08
Last modified date 2002-04-08

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

APAR is sysrouted TO one or more of the following:

Modules/Macros
JDBC          

Fix information
Fixed component name WEBSPHERE AE SO
Fixed component ID 5630A2202

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 #: PQ59880
IBM Group: Software Group
Modified date: Apr 8, 2002