PQ89354: java.sql.SQLException: JZ0C0: Connection is already closed error occurs when connections are closed on the database server side. | |||||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||||
![]() 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 is sysrouted FROM one or more of the following: PQ79650 APAR is sysrouted TO one or more of the following: Modules/Macros
Publications Referenced
|
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
(C) Copyright IBM Corporation 2000, 2009. All Rights Reserved.