db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Legolas Woodland <legola...@gmail.com>
Subject Re: What is wrong with this sql script , im sure that it is ok , but derby return error.
Date Tue, 03 Jan 2006 15:31:33 GMT
Øystein Grøvlen wrote:
>>>>>> "LW" == Legolas Woodland <legolas.w@gmail.com> writes:
>     LW> Hi
>     LW> Thank you for reading my post.
>     LW> can some one please check and see what is wrong with this scripts ?
>     LW> im sure that they should execute but derby return errors like :
>     LW> org.apache.derby.client.am.SqlException:                    Constraints
>     LW> 'SQL060103004635123'  and 'SQL060103004635121'  have the  same  set of
>     LW> columns, which is not allowed.
> I think this is a usability issues since the error message is not very
> helpful in order to figure out what is the cause of this error.  I
> have filed a jira issue, DERBY-789, for this.
I think you missed a post about this error.
One of users answered the question , as he said , I should remove unique 
from field that are in PK.
by the way if you think i should supply more about this error then , 
please let me know the path to submit more details.

View raw message