|
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. |
|
|
|
|
|
|