|
Problem IC73030
|
Status: Geschlossen |
AT V97FP2, SQL0365N ERROR OCCURS WHEN 'UPDATE ... WHERE CURRENT OF' IS USED BY AN APPLICATION USING JCC DRIVER |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
An application using jcc driver gets a -365 error on an execute
immediate.
ErrorID : -365
Error Message : The value of the extended indicator variable in
position "0" is not valid. SQLCODE=-365, SQLSTATE=22539,
DRIVER=3.59.81
The error is detected by sqlriridc due to extended indicator
setting mismatch for the update and the cursor. The extended
indicator is a new function of v97fp2 and it is by default
turned on for jcc driver. The error happens when application
uses 'UPDATE ... where current of' as the following sample.
PreparedStatement stmt1 = conn.prepareStatement("SELECT
C1, C2 FROM T1 WHERE C1 = 1 FOR UPDATE");
Statement stmt2 = conn.createStatement();
ResultSet rs = stmt1.executeQuery();
String cursorname = rs.getCursorName();
while (rs.next())
{
if (rs.getInt("C1") == 1){
int updateCount = stmt2.executeUpdate("UPDATE T1
SET C2='12345' WHERE CURRENT OF " + cursorname);
rs.updateString("C2","12345");
rs.updateRow();
}
} |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* An application using jcc driver gets a -365 error on an *
* execute immediate. *
* *
* ErrorID : -365 *
* Error Message : The value of the extended indicator variable *
* in position "0" is not valid. SQLCODE=-365, SQLSTATE=22539, *
* DRIVER=3.59.81 *
* *
* The error is caused by extended indicator setting mismatch *
* for the update and the cursor. The extended indicator is a *
* new function of v97fp2 and it is by default turned on for *
* jcc driver. The error happens when application uses 'UPDATE *
* ... where current of' . *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.7 FixPack 4. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 |
This was first fixed by V97 FP4. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC73226
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 06.12.2010
02.05.2011
02.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
