|
Problem IC79655
|
Status: Geschlossen |
QUERY GENERATOR IS NOT CHECKING IF COLUMN NAME IS CASE SENSITIVE AND USING COLUMN NAME WITHOUT QUOTES RESULTING IN EXCEPTION |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
When generated keys is specified in a prepared statement, and
useIdentityValLocalForAutoGeneratedKeys property is set to
'false' or not set, JCC generates a SELECT FROM INSERT
query to retrieve generated keys.
However, the query generator is not checking if the column name
is case sensitive (it should be within quotes if it is) and
using the column name without quotes results in an invalid
column SQL exception. |
| Problem-Zusammenfassung: |
See ERROR DESCRIPTION. |
| Local-Fix: |
Set useIdentityValLocalForAutoGeneratedKeys=true |
| Lösung |
First fixed with JDBC driver bundled with v9.5 Fixpack 8.
This affects applications which use the JDBC driver. |
| Workaround |
See LOCAL FIX. |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 07.11.2011
09.01.2012
09.01.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP8
|
| Problem behoben lt. FixList in der Version |
