[
https://issues.apache.org/jira/browse/GEODE-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16412233#comment-16412233
]
ASF subversion and git services commented on GEODE-4894:
--------------------------------------------------------
Commit da51fceefce757df055e3baaf8a4764a04b5ff66 in geode's branch
refs/heads/develop from [~agingade]
[ https://gitbox.apache.org/repos/asf?p=geode.git;h=da51fce ]
GEODE-4894: Changes are made to support case sensitivity between region, table
name and pdx field, column name (#1663)
* meta-data is now used to compute the column name
* reads will now consult the pdx registry for an existing pdx type to use its
field name.
* Convert field name to lowercase only when column name is uppercase.
* Table name lookup is changes to look for exact match first, than case
insensitive match.
* Field to column name lookup is changed to find exact column name or case
insensitive match in the metadata.
> JDBC connector needs to be work with databases support for mixed case
> identifiers
> ---------------------------------------------------------------------------------
>
> Key: GEODE-4894
> URL: https://issues.apache.org/jira/browse/GEODE-4894
> Project: Geode
> Issue Type: Bug
> Components: docs, extensions, regions
> Affects Versions: 1.4.0
> Reporter: Darrel Schneider
> Assignee: Darrel Schneider
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Currently, the jdbc connector will convert a database column name to all
> lower case if a region mapping for that column does not exist. But it is
> possible that the database supports mixed case identifiers in which case the
> connector should honor the mixed case column name.
> Also, when the connector is creating the prepared statement, the string it
> uses does not quote the column names in that string. They should be quoted
> since the database may support mixed case quoted identifiers.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
