Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 8BF62200B50 for ; Fri, 29 Jul 2016 13:16:22 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 8A81C160A79; Fri, 29 Jul 2016 11:16:22 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id D6C99160A61 for ; Fri, 29 Jul 2016 13:16:21 +0200 (CEST) Received: (qmail 21198 invoked by uid 500); 29 Jul 2016 11:16:21 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 21178 invoked by uid 99); 29 Jul 2016 11:16:21 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 29 Jul 2016 11:16:21 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id E461B2C029E for ; Fri, 29 Jul 2016 11:16:20 +0000 (UTC) Date: Fri, 29 Jul 2016 11:16:20 +0000 (UTC) From: "Danoja Dias (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DERBY-5585) Improve error messages used when Derby can't find the class or method backing up a SQL routine or type MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Fri, 29 Jul 2016 11:16:22 -0000 [ https://issues.apache.org/jira/browse/DERBY-5585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danoja Dias updated DERBY-5585: ------------------------------- Attachment: Derby5585_3.diff With Derby5585_3.diff patch tests were fine. > 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, Derby5585_3.diff, errors.zip > > > 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)