APAR status
Closed as program error.
Error description
Customer has a clustered environment with WAS v5.0.2.6 ND,
database is MS SQLServer 2000 Enterprise SP2, JDBC
Driver used is Microsoft JDBC Driver for SQL Server 2.2...,
version 5 datasource is used for their application.
Application runs fine, but fails to reconnect to database
when they stop and restart the Database server. The exception
logged in the tracefile is:
[8/16/04 17:29:57:922 CDT] 544e483b WSRdbManagedC d DSA_ERROR
[Microsoft][SQLServer 2000
Driver for
JDBC]Connection reset by peer: socket write error
[8/16/04 17:29:57:922 CDT] 544e483b WSRdbManagedC d
SQL_STATE_ERROR_CODE
08S01
0
[8/16/04 17:29:57:922 CDT] 544e483b WSRdbManagedC d Exception
java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by
peer:
socket write error
at
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)........
For some timing reason, this exception is not mapped to a
StaleConnectionException. But if customer uses version 4
datasource instead of version 5, then customer does not have any
problem.
Local fix
Right now, customer's work around is to restart the AppServer.
Problem summary
****************************************************************
* USERS AFFECTED: All WebSphere Application server users *
* who use J2C connection pooling *
****************************************************************
* PROBLEM DESCRIPTION: An SQL Exception which would *
* otherwise be mapped to *
* StaleConnectionException might not *
* be mapped. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
One window was found on getConnection where a connection
from the pool which is stale might not issue a
StaleConnectionException.
Problem conclusion
The problem has been corrected.
Temporary fix Comments
APAR information |
APAR number |
PQ93018 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
00W |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2004-08-18 |
Closed date |
2004-09-14 |
Last modified date |
2004-11-03 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
Applicable component levels |
R003 PSY |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
R103 PSY |
UP |
R10A PSY |
UP |
R10H PSY |
UP |
R10I PSY |
UP |
R10P PSY |
UP |
R10S PSY |
UP |
R10W PSY |
UP |
|