From derby-dev-return-30074-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Mon Sep 18 21:01:19 2006 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 88786 invoked from network); 18 Sep 2006 21:01:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 18 Sep 2006 21:01:19 -0000 Received: (qmail 41617 invoked by uid 500); 18 Sep 2006 21:01:17 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 41578 invoked by uid 500); 18 Sep 2006 21:01:17 -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 41525 invoked by uid 99); 18 Sep 2006 21:01:17 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Sep 2006 14:01:16 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Sep 2006 14:01:16 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 3BA397142FE for ; Mon, 18 Sep 2006 20:57:24 +0000 (GMT) Message-ID: <4626629.1158613044241.JavaMail.jira@brutus> Date: Mon, 18 Sep 2006 13:57:24 -0700 (PDT) From: "A B (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-1772) Error 42Z78 "Failed to locate 'Xalan' API classes" should not have sqlstate class '42' In-Reply-To: <13912775.1156825642304.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/DERBY-1772?page=all ] A B updated DERBY-1772: ----------------------- Attachment: d1772_v1.patch Attaching the simplest patch possible for this issue--just changes SQLSTATE '42Z78' to a Derby-specific SQLSTATE, 'XML00'. I also moved SQLSTATE '42Z7Z' to 'XML01' since I believe it falls into the same category of "Derby-specific errors that are not covered by the SQLStandard." I read through the SQL standard definitions for SQLSTATES and none of them jumped out at me as being more appropriate than '42', so I just created a new set of SQLSTATEs, "XMLxx", for this particular issue. As I said, this was just the easiest way to go; if anyone can suggest a better SQLSTATE to fit the errors, please let me know. Otherwise, the d1772_v1.patch should be all it takes to resolve this issue. Note: Since we don't currently have any tests for cases where the classpath is missing the required Xalan/JAXP classes, there were no test/master files to update. The need to add tests for such scenarios is filed as part of DERBY-1758. Review/feedback/commit would be much appreciated. > Error 42Z78 "Failed to locate 'Xalan' API classes" should not have sqlstate class '42' > --------------------------------------------------------------------------------------- > > Key: DERBY-1772 > URL: http://issues.apache.org/jira/browse/DERBY-1772 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.2.1.0 > Reporter: Daniel John Debrunner > Priority: Minor > Attachments: d1772_v1.patch > > > This is a run-time error but it has the SQL state '42' for compile error, and thus in Java SE 6 will have a SQLException of type SQLSyntaxErrorException. > ERROR 38000: The exception 'java.sql.SQLSyntaxErrorException: Failed to locate ' > Xalan' API or implementation classes. XML operations are not permitted unless t > hese classes are in your classpath.' was thrown while evaluating an expression. > ERROR 42Z78: Failed to locate 'Xalan' API or implementation classes. XML operat > ions are not permitted unless these classes are in your classpath. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira