[teiid-issues] [JBoss JIRA] (TEIID-3893) Handling of binary odbc parameters needs improvded

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-3893.
-----------------------------------
    Resolution: Partially Completed


We now have handling for binary numeric types, but not for date/time, arrays, etc.  Those have more involved handling that will require additional code to be taken from the pg client or elsewhere.  The best solution is to have the client disable binary parameters when possible, for example with the jdbc client use binaryTransfer=false as a connection parameter - https://wiki.postgresql.org/wiki/JDBC-BinaryTransfer

> Handling of binary odbc parameters needs improvded
> --------------------------------------------------
>
>                 Key: TEIID-3893
>                 URL: https://issues.jboss.org/browse/TEIID-3893
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: ODBC
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.13, 8.12.4
>
>
> parameters sent in binary format are just treated as byte arrays.  We should us the oids sent with prepare to convert into the expected values.  Clients such as postgresql JDBC 9.2+ expect this handling unless configured to not use binary values.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)