[ 
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

Reply via email to