db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5585) Improve error messages used when Derby can't find the class or method backing up a SQL routine or type
Date Wed, 27 Jul 2016 14:00:28 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15395719#comment-15395719
] 

Bryan Pendleton commented on DERBY-5585:
----------------------------------------

I propose replacing 
{quote}
un/misconfiguration of derby.database.classpath property
{quote}
with
{quote}
the derby.database.classpath property is missing or incorrectly defined
{quote}

Also, what do you think about including Rick's simple repro into one of the
user-defined-functions test suites, as a new test case?

> Improve error messages used when Derby can't find the class or method backing up a SQL
routine or type
> ------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5585
>                 URL: https://issues.apache.org/jira/browse/DERBY-5585
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.9.1.0
>            Reporter: Rick Hillegas
>            Assignee: Danoja Dias
>            Priority: Minor
>              Labels: derby_triage10_10
>         Attachments: Derby-5585.diff
>
>
> When the code supporting user-written routines and types is put into jar files in the
database, the user also needs to wire the jar files together by setting the derby.database.classpath
 property. People often neglect to do this and Derby documentation in this area could be improved.
It would be good to at least improve the error messages which Derby raises in this situation:
42X50 and 42X51. Those messages should tell the user that one of the reasons for the failure
might be an un/misconfigured derby.database.classpath  property. The following script shows
the error messages:
> connect 'jdbc:derby:memory:db;create=true;user=test_dbo;password=test_dbopassword';
> create function foo( a int ) returns int
> language java parameter style java no sql
> external name 'Bop.doowop';
> create function bar( a int ) returns int
> language java parameter style java no sql
> external name 'java.lang.Integer.doowop';
> values ( foo( 1 ) );
> values ( bar( 1 ) );



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message