[GEODE-4922] JDBC connector does not handle java.util.Date

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

Description

Pdx types can have java.util.Date fields or object fields that contain java.util.Date.

When these are written that java.util.Date may cause a failure from the jdbc driver if it does not support java.util.Date. Jdbc drivers must support java.sql.Date, java.sql.Time, and java.sql.Timestamp but may not support java.util.Date.

The JDBC connector should convert java.util.Date to one of the java.sql interfaces using the data type of the column to determine which one to convert it to.

When reading from jdbc back into geode if the pdx field is java.util.Date then we should convert the java.sql.* instance to java.util.Date. It is also possible we should do this conversion if the pdx field is of type object.

 

Issue Links

• links to: GitHub Pull Request #1686