SQLState HY000 and ErrorCode 0 in WebSphere 4.0V
 Technote (FAQ)
 
Problem
SQLState HY000 and ErrorCode 0 for the following exception:
java.sql.SQLException: °IBMé°SQLServer JDBC DriveréNo more data
available to read is thrown instead of StaleConnectionException
 
Cause
PQ82377 is for version 5.0 dataSource (WAS.adapter), which is not
applicable to V4.0. Customer datasource is jdbc. Also, J2C function in WebSphere
V4.0 was reviewed but is not recommended for production systems.
 
Solution
Implement 3.3.33 version of DataDirect Connect JDBC Driver to use with 4.0. This is already available on the web at:

ftp://ftp.software.ibm.com/software/websphere/info/tools/DataDirect/datadirect.htm#Connect3.3

Bear in mind also, that in the 4.0 CM code, all the base SQL States are mapped, 08001, 08003, 08006, and 08S01. But the additional 08000/2/4/7 are not. They have to be custom mapped to SCE by the customer should they be encountered.
 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 4.0
Software edition:
Reference #: 1193464
IBM Group: Software Group
Modified date: Mar 28, 2006