[jira] Commented: (DERBY-925) Implement new JDBC 4 metadata API getFunctionParameters()

["Dyre Tjeldvoll (JIRA)" <de...@db.apache.org>]

    [ http://issues.apache.org/jira/browse/DERBY-925?page=comments#action_12367858 ] 

Dyre Tjeldvoll commented on DERBY-925:
--------------------------------------

As far as I can tell it is not possible to obtain all the necessary information from Derby's existing system tables. The getProcedureColumns() method needs much of the same information, but solves the problem by joining SYSALIASES and SYSSCHEMAS with a the VTI GetProcedureColumns.java.

I think it will be difficult to extend it so that it works for getFunctionParameters() as well, but I think should be relatively easy to implement a new VTI along the same lines (with some new columns, and a row for the return value). 

> Implement new JDBC 4 metadata API getFunctionParameters()
> ---------------------------------------------------------
>
>          Key: DERBY-925
>          URL: http://issues.apache.org/jira/browse/DERBY-925
>      Project: Derby
>         Type: New Feature
>   Components: JDBC
>     Versions: 10.2.0.0
>  Environment: JDK 1.6
>     Reporter: David Van Couvering
>     Assignee: Dyre Tjeldvoll

>
> I am currently implementing this to return an empty result set so at least we're compliant, but we should be able to provide real metadata here.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira