db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-3005) Document possibility to specify method signature in EXTERNAL NAME when creating a procedure/function
Date Thu, 22 Jan 2015 19:51:34 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Myrna van Lunteren updated DERBY-3005:
    Attachment: DERBY-3005_2.diff

Thanks for the review Kim!

Attaching a new patch; I was not pleased with the attempt to describe the use of the signatures
in the external name as given as a solution to passing SQL NULLs to primitive types in the
referenced user list thread and FAQ. After some thought I decided to just leave that section
out, I felt it only looked confusing.
I also thought about commenting that although you can specify signatures, you still cannot
overload a SQL function in Derby (i.e., you cannot use the same name for two different functions)
but decided against that too, better to document what *is* supported.

I did fix up the little issues.
I intend to commit this second patch soon. As always further changes can always be made later.

> Document possibility to specify method signature in EXTERNAL NAME when creating a procedure/function
> ----------------------------------------------------------------------------------------------------
>                 Key: DERBY-3005
>                 URL: https://issues.apache.org/jira/browse/DERBY-3005
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions:
>            Reporter: Kristian Waagan
>            Assignee: Myrna van Lunteren
>         Attachments: DERBY-3005.diff, DERBY-3005_2.diff, rrefsqljexternalname.html, rrefsqljexternalname.html
> In some cases it might be necessary to specify the method signature of the external method
used as a function or procedure in Derby (using CREATE FUNCTION or CREATE PROCEDURE).
> This possibility is not documented in the manuals, but there is an entry in the FAQ (http://db.apache.org/derby/faq.html#null_args):
> Either declare the function with RETURNS NULL ON NULL INPUT or define the Java method
signature in the external name clause. See the "Create function problem"  derby-user mail
list topic.
> The mail thread: http://mail-archives.apache.org/mod_mbox/db-derby-user/200602.mbox/%3c4404E53D.1050605@apache.org%3e
> The relevant sections in the manuals should be updated to describe the feature.

This message was sent by Atlassian JIRA

View raw message