|
Problem IC79655
|
Status: Closed |
QUERY GENERATOR IS NOT CHECKING IF COLUMN NAME IS CASE SENSITIVE AND USING COLUMN NAME WITHOUT QUOTES RESULTING IN EXCEPTION |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
See ERROR DESCRIPTION. |
| Local Fix: |
Set useIdentityValLocalForAutoGeneratedKeys=true |
| Solution |
First fixed with JDBC driver bundled with v9.5 Fixpack 8.
This affects applications which use the JDBC driver. |
| Workaround |
See LOCAL FIX. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.11.2011
09.01.2012
09.01.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
