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 fixProblem 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 fixComments
APAR information | APAR number | PQ55196 | Reported component name | WAS ADVANCED AI | Reported component ID | 5648C8400 | Reported release | 350 | Status | CLOSED PER | PE | NoPE | HIPER | NoHIPER | Submitted date | 2001-11-28 | Closed date | 2002-01-17 | Last modified date | 2002-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 APAR is sysrouted TO one or more of the following:Modules/Macros
|
Fix information |
Fixed component name | WAS ADVANCED AI | Fixed component ID | 5648C8400 |
Applicable component levels | R350 PSY | UP |
|