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 is sysrouted FROM one or more of the following: PQ56104 APAR is sysrouted TO one or more of the following: Modules/Macros
|
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
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.