|
Problem IC95436
|
Status: Closed |
JDBC DOESN'T REPORT SQLCODE 100 WHEN NO DATA IS UPDATED OR DELETED |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
JDBC wrapper doesn't report SQLCODE +100 when no data is
updated or deleted. This because the JDBC driver doesn't
report any warning when NO data is updated or deleted.
For example:
db2 => SELECT * FROM N1
c1 c2
----------- ----------
1 3343
2 123
2 record(s) selected.
db2 => UPDATE N1 SET "c1" = '123' where "c1"=3
DB20000I The SQL command completed successfully.
The expected result is:
SQL0100W No row was found for FETCH, UPDATE or DELETE; or the
result of a
query is an empty table. SQLSTATE=02000 |
| Problem Summary: |
User affected:
Users who use JDBC wrapper of InfoSphere Federation Server
Problem description and summay:
See error description |
| Local Fix: |
Please contact the vendor of JDBC driver and make sure there is
SQLWarning with SQLSTATE 100 reported after executing the SQL. |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem was fistly fixed in Version 10.5 FixPak 3. This
fix should be applied on the federation Server. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
10.03.2014
10.03.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
