[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1164) Getting the Procedure Parameter metadata is not supported in ODBC

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy resolved TEIID-1164.
---------------------------------

    Resolution: Done


The metadata is now fixed with some caveats. The procedures in Teiid allow inout/out/resultset/return at any time, however PG does not.

return, resultset can only used if there are no inout,out parameters. So, as long as procedures defined in Teiid follow the conditions of the PG everything will work fine.

> Getting the Procedure Parameter metadata is not supported in ODBC
> -----------------------------------------------------------------
>
>                 Key: TEIID-1164
>                 URL: https://issues.jboss.org/browse/TEIID-1164
>             Project: Teiid
>          Issue Type: Bug
>          Components: ODBC
>    Affects Versions: 7.1
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 7.4
>
>
> Currently postgreSQL uses the JDBC array types in issuing the query  to read the Procedure parameters. However, Teiid does not support the Array types yet in the JDBC layer, thus this is currently not implemented. This needs to be fixed to correctly return the metadata about the procedures.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira