db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: unique columns must be nullable ?
Date Tue, 12 Dec 2006 13:49:36 GMT
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
>
>   


Mime
View raw message