[
https://issues.apache.org/jira/browse/DERBY-5585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bryan Pendleton reopened DERBY-5585:
------------------------------------
Hi Danoja,
When I run the 'lang' suite of tests after this patch is applied, I see
failures in 3 tests. I'll attach the test output in a moment.
To see these failures on your system, you should be able to do:
{code}
ant
-Dderby.junit.testclass=org.apache.derbyTesting.functionTests.tests.lang._Suite
junit-clean junit-single
{code}
Can you have a look at these tests and see what you think?
thanks,
bryan
> 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
> Fix For: 10.13.0.0
>
> Attachments: Derby-5585.diff, Derby-5585_2.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)
