|
Problem IC77656
|
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 / 970 - 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: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade JDBC driver to the one included with v9.7 Fixpack 5. *
**************************************************************** |
| Local Fix: |
Set useIdentityValLocalForAutoGeneratedKeys=true |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 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
|
| Solution |
Problem was first fixed in the JDBC driver included with v9.7
Fixpack 5. This is a client side fix. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC79655
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.07.2011
04.07.2012
04.07.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
