[GEODE-4894] JDBC connector needs to be work with databases support for mixed case identifiers

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.0
• Fix Version/s: 1.6.0
• Component/s: docs, extensions, regions
• Labels: pull-request-available
• Assignee: Darrel Schneider
• Reporter: Darrel Schneider
• Created: 19/Mar/18 19:07
• Updated: 02/May/18 18:21
• Resolved: 24/Mar/18 17:29

Description

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.

 

Issue Links

• duplicates: GEODE-4875 JdbcLoader will not always find an existing pdx field type if it is not all lower case
• links to: GitHub Pull Request #1663