PQ55196: UNEXPECTED SQL ERROR RETURNS ON PREPAREDSTATEMENT WHEN USING WASDATASOURCE AND PREPAREDSTATEMENT CACHE ON.

A fix is available
3.5.4-3.5.7, 4.0.2-4.0.7: Component cumulative Connection Manager fix

APAR

APAR status
Closed as program error.

Error description
The customer having problem when inserting UDB blob type data
via WAS datasource. get CLI0112E with SQLSTATE=22005 data
assignment error on blob type data on 3rd insertion with same
primary key.
first insert ended normal. and second insert get 23505,
duplicate key. then 3rd insert get 22005 .
our expectation is 3rd insert also returns 23505
(duplicate key).
This problem des not occur when set statementCacheSize
value set to 0 in datasources.xml
Local fix
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users of        *
*                 PreparedStatements                           *
****************************************************************
* PROBLEM DESCRIPTION: Using a preparedStatement with BLOB     *
*                      data type, would produce a CLI0112E     *
*                      with SQLSTATE=22005 data assignment     *
*                      error on blob type data.                *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When certain data types were being used, the parameters were
not being cleared in the cached preparedStatements.
Problem conclusion
The code was not calling clearParameters() on the
preparedStatements going back into the cache.  When
a call to clearParameters() was added, the problem was
resolved.
Temporary fix
Comments
APAR information
APAR numberPQ55196
Reported component nameWAS ADVANCED AI
Reported component ID5648C8400
Reported release350
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Submitted date2001-11-28
Closed date2002-01-17
Last modified date2002-01-17

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:APAR is sysrouted FROM one or more of the following:


Modules/Macros
JDBC
APAR is sysrouted TO one or more of the following:Modules/Macros

Fix information
Fixed component nameWAS ADVANCED AI
Fixed component ID5648C8400

Applicable component levels
R350 PSYUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ55196
IBM Group: Software Group
Modified date: 2002-01-17