Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (nike.apache.org: domain of
 lists+1214986160035-208411@n2.nabble.com designates 216.139.236.158 as
 permitted sender)
Date: Tue, 8 Dec 2009 00:46:26 -0800 (PST)
From: cmoulliard <cmoulliard@xpectis.com>
To: users@openjpa.apache.org
Message-ID: <1260261986826-4131234.post@n2.nabble.com>
In-Reply-To: <d486f41c0912070849o3068cbbdv2c95b279d8fff54c@mail.gmail.com>
References: <a364c40b0912070805v6df9e37dq938be2c5f33bada1@mail.gmail.com>
 <E0529A8FFC2C9143A5F1BB9A89101D060789C747@BD01MSXMB018.US.Cingular.Net>
 <d486f41c0912070849o3068cbbdv2c95b279d8fff54c@mail.gmail.com>
Subject: Re: Violation of unique constraint $$: duplicate value(s) for
 column
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


I have set the field name with a default value in the class ProcessDefinition
but the error is still there. If I remove the annotation on the method
getName, it works !!!

    //@Column(unique = true) 
    public String getName() {
        return name;
    }

What is the solution for HSQL DB ?

Remark : Even if the reason of the message displayed in the error is that
the field null, the message displayed is not very helpfull for the user
(Violation of unique constraint $$: duplicate value(s) for column) --> must
Violation of unique constraint $$: cannot insert null value(s) for column
!!!

Regards,

Charles


Daryl Stultz wrote:
> 
> On Mon, Dec 7, 2009 at 11:37 AM, KARR, DAVID (ATTCINW)
> <dk068x@att.com>wrote:
> 
>> It doesn't make sense to have a unique constraint on a
>> NULLABLE column.
>>
> 
> I disagree. A property can be optional and be required to be unique when
> it
> is specified. In my application I have such a case. I omitted the Unique
> annotation from my class but left the constraint in the database (OpenJPA
> refused to insert null into a foreign key column). Using PostgreSQL, nulls
> are ignored regarding uniqueness.
> 
> -- 
> Daryl Stultz
> _____________________________________
> 6 Degrees Software and Consulting, Inc.
> http://www.6degrees.com
> mailto:daryl@6degrees.com
> 
> 

-- 
View this message in context: http://n2.nabble.com/Violation-of-unique-constraint-duplicate-value-s-for-column-tp4126767p4131234.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.