[
https://issues.apache.org/jira/browse/GEODE-4922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16416127#comment-16416127
]
ASF subversion and git services commented on GEODE-4922:
--------------------------------------------------------
Commit 1307696270a571b94a24bc4dace9bc2ab1bc104a in geode's branch
refs/heads/develop from [~dschneider]
[ https://gitbox.apache.org/repos/asf?p=geode.git;h=1307696 ]
GEODE-4922: handle Date conversion (#1686)
When writing a java.util.Date the column type will be used
to convert it to a java.sql.Date, java.sql.Time, or java.sql.Timestamp.
When reading a pdx DATE field, the column type will be used to
decide if getDate, getTime, or getTimestamp is called.
When reading a pdx OBJECT field, if getObject returns an instance of
java.sql.Date, java.sql.Time, or java.sql.Timestamp then it will be
converted to java.util.Date and that will be stored in the pdx field.
> JDBC connector does not handle java.util.Date
> ---------------------------------------------
>
> Key: GEODE-4922
> URL: https://issues.apache.org/jira/browse/GEODE-4922
> Project: Geode
> Issue Type: Bug
> Components: 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
>
> 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.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
