Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 79353 invoked from network); 28 Jun 2008 20:33:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 28 Jun 2008 20:33:42 -0000 Received: (qmail 76245 invoked by uid 500); 28 Jun 2008 20:33:42 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 76215 invoked by uid 500); 28 Jun 2008 20:33:42 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 76204 invoked by uid 99); 28 Jun 2008 20:33:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 28 Jun 2008 13:33:42 -0700 X-ASF-Spam-Status: No, hits=-1.0 required=10.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.18.43.24] (HELO sca-ea-mail-1.sun.com) (192.18.43.24) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 28 Jun 2008 20:32:50 +0000 Received: from dm-uk-02.uk.sun.com ([129.156.101.196]) by sca-ea-mail-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m5SKWxsK029875 for ; Sat, 28 Jun 2008 20:32:59 GMT Received: from barman.uk.sun.com (barman.UK.Sun.COM [129.156.132.12]) by dm-uk-02.uk.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id m5SKWwJJ002595 for ; Sat, 28 Jun 2008 21:32:58 +0100 (BST) Received: from vpn-129-150-121-16.uk.sun.com ([129.150.121.16]) by barman.uk.sun.com with esmtp (Exim 4.42) id 1KCh7w-0004QI-47 for derby-user@db.apache.org; Sat, 28 Jun 2008 21:34:32 +0100 Message-ID: <48669FF9.7030609@sun.com> Date: Sat, 28 Jun 2008 21:32:57 +0100 From: Alan Burlison User-Agent: Thunderbird 2.0.0.12 (X11/20080422) MIME-Version: 1.0 To: Derby Discussion Subject: Re: java.lang.NullPointerException. [XJ001] on update References: <4865DE69.3060904@sun.com> <4865E2CF.9040906@sun.com> <486606F4.2040409@sun.com> <486693DC.8010505@sun.com> In-Reply-To: <486693DC.8010505@sun.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Alan Burlison wrote: > Would it be a better option to switch back to 10.3.3.0? Short answer: No. 10.3 doesn't allow nulls in a PK index, so the trick of doing an insert with nulls in the derived lowercase columns and using the triggers to populate them doesn't work. Looks like whatever I do I'm stuffed. Ah well, back to the do-it-all-by-hand approach... All this buggering around because Derby doesn't do case insensitive indexes, sigh... -- Alan Burlison --