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: Customers using The J2C style datasource to *
* create database connections to Sybase *
* database servers. *
****************************************************************
* PROBLEM DESCRIPTION: Sybase SQL Exceptions with an SQLState *
* of JZ006 and a sub-SQLException with *
* an SQLState of JZ0C0, were not being *
* mapped to a StaleConnectionException. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
Because SQLExceptions are not being appropriately mapped to
StaleConnectionExceptions, when a database outage occurs,
it is possible that the connection pools will not be able
to recover. The customer will continue to encounter the
same SQLExceptions each time they attempt to use a database
connection. The only way to recover the connection pools
in this scenario is to restart the application server.
As a workaround, the customer can configure a user-defined
DataStoreHelper class which inherits from the basic
SybaseDataStoreHelper class, and manually add this
SQLException to the StaleConnectionException mapping.
Problem conclusion
The StaleConnectionException mapping for Sybase was modified
so that an SQLException with an SQLState of JZ006 and a
sub-SQLException with an SQLState of JZ0C0 are appropriately
mapped to a StaleConnectionException. This allows the
WebSphere runtime to automatically recover the connection
pools without a restart of the application server.
Temporary fix Comments
APAR information |
APAR number |
PQ79650 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
00A |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2003-10-15 |
Closed date |
2003-12-17 |
Last modified date |
2004-05-25 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PQ89354
Modules/Macros
Publications Referenced
Applicable component levels |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
|