[teiid-issues] [JBoss JIRA] (TEIID-5817) zero precision loaded for java.sql.Timestamp

[Steven Hawkins (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins moved TEIIDSB-118 to TEIID-5817:
-----------------------------------------------

              Project: Teiid  (was: Teiid Spring Boot)
                  Key: TEIID-5817  (was: TEIIDSB-118)
          Component/s: OData
                       Query Engine
                           (was: datasource)
                           (was: OData)
    Affects Version/s:     (was: 1.2.0)


> zero precision loaded for java.sql.Timestamp
> --------------------------------------------
>
>                 Key: TEIID-5817
>                 URL: https://issues.jboss.org/browse/TEIID-5817
>             Project: Teiid
>          Issue Type: Bug
>          Components: OData, Query Engine
>            Reporter: Renat Eskenin
>            Priority: Major
>         Attachments: image-2019-09-20-13-30-58-536.png, image-2019-09-20-13-34-56-255.png
>
>
> I create spring-boot project for translate jdbc connection from vertica JDBC to odata4 REST interface.
> Base project is spring-odata-example in teiid git.
> When i get request to object with field witch Timestamp type i get the exception:
> Request:
> GET /vertica-odata-facade/odata/vertica/domain?%24top=1
> Response:
> {
>   "error": {
>     "code": null,
>     "message": "The value '2019-09-12 09:26:22.323764' is not valid for property 'created_date'."
>   }
> }
> This field in vertica
>  !image-2019-09-20-13-34-56-255.png|thumbnail! 
> name: created_by_id
> type: Timestamp
> column size: 26
> decimal digits: 6



--
This message was sent by Atlassian Jira
(v7.13.8#713008)