[jira] Updated: (DERBY-3809) Add a SHOW FUNCTONS command to ij

["Sylvain Leroux (JIRA)" <ji...@apache.org>]

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

Sylvain Leroux updated DERBY-3809:
----------------------------------

    Attachment: DERBY-3809.patch

Surprisingly, it was not that instantaneous!

AbstractMethodError should be wrapped in a InvocationTargetException. But, according to http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6531596, with some Sun VM this is not the case.

So, I wrote the patch defensively against this by catching "direct" AbstractMethodError as well as those wrapped inside an InvocationTargetException.

While running against Postgre-8.3 I now have the expected behavior:
ij> DRIVER 'org.postgresql.Driver';
ij> CONNECT 'jdbc:postgresql:ij?user=ij&password=ijpw';
ij> SHOW FUNCTIONS;
ij> IJ ERROR: command not available for this driver: PostgreSQL Native Driver

Pass ToolScripts without error.

> Add a SHOW FUNCTONS command to ij
> ---------------------------------
>
>                 Key: DERBY-3809
>                 URL: https://issues.apache.org/jira/browse/DERBY-3809
>             Project: Derby
>          Issue Type: Improvement
>          Components: Tools
>    Affects Versions: 10.4.1.3
>            Reporter: Rick Hillegas
>            Assignee: Sylvain Leroux
>             Fix For: 10.6.0.0
>
>         Attachments: DERBY-3809.patch, show-functions-2.diff, show-functions-3.diff, show-functions.diff
>
>
> Currently, the ij SHOW command can give you information on a number of schema objects, including procedures. It should be fairly easy to add SHOW FUNCTIONS as well. This request surfaced on the user list: http://www.nabble.com/How-can-i-see-my-self-defined-functions--td18773980.html#a18773980

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.