Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 78209 invoked from network); 12 Dec 2006 13:50:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 12 Dec 2006 13:50:49 -0000 Received: (qmail 91688 invoked by uid 500); 12 Dec 2006 13:50:55 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 91659 invoked by uid 500); 12 Dec 2006 13:50:55 -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 91648 invoked by uid 99); 12 Dec 2006 13:50:55 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Dec 2006 05:50:55 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [192.18.42.249] (HELO nwk-ea-fw-1.sun.com) (192.18.42.249) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Dec 2006 05:50:43 -0800 Received: from d1-sfbay-10.sun.com ([192.18.39.120]) by nwk-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id kBCDoFQU000649 for ; Tue, 12 Dec 2006 05:50:15 -0800 (PST) Received: from conversion-daemon.d1-sfbay-10.sun.com by d1-sfbay-10.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0JA500C01Y7YOP00@d1-sfbay-10.sun.com> (original mail from Richard.Hillegas@Sun.COM) for derby-user@db.apache.org; Tue, 12 Dec 2006 05:50:15 -0800 (PST) Received: from [192.9.61.67] by d1-sfbay-10.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JA500D52YFRNTT7@d1-sfbay-10.sun.com> for derby-user@db.apache.org; Tue, 12 Dec 2006 05:50:15 -0800 (PST) Date: Tue, 12 Dec 2006 05:49:36 -0800 From: Rick Hillegas Subject: Re: unique columns must be nullable ? In-reply-to: <20061212102809.GC14663@atum01.norway.sun.com> Sender: Richard.Hillegas@Sun.COM To: Derby Discussion Message-id: <457EB370.9050708@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT References: <20061212102809.GC14663@atum01.norway.sun.com> User-Agent: Thunderbird 1.5.0.5 (X11/20060828) X-Virus-Checked: Checked by ClamAV on apache.org DERBY-653 may be relevant to this issue. Regards, -Rick Bernt M. Johnsen wrote: >>>>>>>>>>>>> Xanana Gusmao wrote (2006-12-12 04:08:39): >>>>>>>>>>>>> >> On this page http://wiki.apache.org/db-derby/HibernateHelp >> it says: >> >> "Hibernate Annotations do not work because Derby does not allow a unique column >> to be nullable" >> >> Is this (that Derby's unique column must be non-nullable) still true >> ? >> > > That's still true. UNIQUE constraint on nullable columns is optional > feature T591 in the SQL standard and not implemented in Derby. See > http://wiki.apache.org/db-derby/SQLvsDerbyFeatures. > > For a longer discussion of the topic, see > http://mail-archives.apache.org/mod_mbox/db-derby-dev/200511.mbox/%3C20051102114053.GB7614@atum01.norway.sun.com%3E > >