PQ89354: java.sql.SQLException: JZ0C0: Connection is already closed error occurs when connections are closed on the database server side.

 A fix is available

Obtain the fix for this APAR



APAR status
Closed as program error.

Error description
When using Sybase Adaptive Server with WebSphere Application
Server version 5.0.2, the following exception occurs when
fail-over to a backup database is initiated:

WSRdbManagedC W DSRA0080E:
An exception was received by the Data Store Adapter. See
original exception message:
java.sql.SQLException: JZ0C0: Connection is already closed.
Local fix
Define a custom map by extending the DataStoreHelper.
Problem summary
****************************************************************
* USERS AFFECTED: All users of WebSphere Application Server    *
*                 V5.0 for z/OS                                *
****************************************************************
* PROBLEM DESCRIPTION: Sybase Exception JZ0C0: Connection is   *
*                      already closed, which occurs when a     *
*                      database fails over to a backup         *
*                      database, is not getting properly       *
*                      mapped to a StaleConnectionException,   *
*                      causing applications to not properly    *
*                      recover.                                *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Applications that use a Connection to a Sybase database that
failed over to a backup database will receive a JZ0C0:
Connection is already closed, exception.  This exception
indicates a Stale Connection, but because it is not received by
the application as a StaleConnectionException, applications with
recovery logic for Stale Connections will not act appropriately
in this situation.  In addition, WebSphere will not properly
purge the Connection from the Connection Pool.
Problem conclusion
This defect has been fixed by including the fix for WebSphere
Application Server for Distributed APAR 
PQ79650, which properly
maps the Sybase Exception JZ0C0 to a StaleConnectionException
before it is thrown to the application.

APAR PQ89354 is associated with SERVICE LEVEL W502011 of
WebSphere Application Server V5.0 for z/OS.
Temporary fix Comments
APAR information
APAR number PQ89354
Reported component name WEBSPHERE FOR Z
Reported component ID 5655I3500
Reported release 500
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2004-05-25
Closed date 2004-06-16
Last modified date 2004-07-02

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

APAR is sysrouted TO one or more of the following:

Modules/Macros
BBOUBINF          

Publications Referenced

Fix information
Fixed component name WEBSPHERE FOR Z
Fixed component ID 5655I3500

Applicable component levels
R500 PSY UQ89659    UP04/06/22 P F406

  Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.


Document Information


Current web document: swg1PQ89354.html
Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS
Operating system(s):
Software version: 500
Software edition:
Reference #: PQ89354
IBM Group: Software Group
Modified date: Jul 2, 2004