|
Problem IC80658
|
Status: Geschlossen |
WHEN UPDATING CLOB COLUMN WITH AN UPDATABLE CURSOR USING JCC, AN EXTRA CHARACTER (HEX VALUE 0) IS INSERTED INTO THE CLOB COLUMN. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
When updating CLOB column with an updatable cursor using JCC, an
extra character (hex value 0) is inserted into the CLOB column.
For example, customer updates CLOB field with string
"1234567890". Issuing select length(clob) from table returns
11 instead of 10
...
// Get the CLOB column
sqlstmt = "SELECT MD_CONTENTS FROM test1"
+ " WHERE MD_CONTENTID =? AND "
+ " MD_PARTITION_ID =?";
pstmt = mConnection.prepareStatement(sqlstmt,
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_UPDATABLE );
pstmt.setLong(1, contentID);
pstmt.setInt(2, partitionID);
rs = pstmt.executeQuery();
rs.next();
Clob clob = rs.getClob(1);
// Populate the Clob transferring the content in
optimum size chunks
int size = -1;
String contents = "1234567890";
try {
BufferedWriter bufWr = new
BufferedWriter(clob.setCharacterStream(1));
bufWr.write(contents.toCharArray(), 0,
contents.length());
bufWr.close();
}
....
rs.updateClob(1, clob);
rs.updateRow();
.... |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All DB2 v9.7 users *
****************************************************************
* PROBLEM DESCRIPTION: *
* When updating CLOB column with an updatable cursor using *
* JCC, an extra character (hex value 0) is inserted into the *
* CLOB column. *
* *
* For example, customer updates CLOB field with string *
* "1234567890". Issuing select length(clob) from table *
* returns 11 instead of 10. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 FP6 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Fixed in DB2 Version 9.7 Fix Pack 6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.01.2012
19.06.2012
19.06.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
