Re: Primary Key error
Re: Primary Key error
- Subject: Re: Primary Key error
- From: Chuck Hill <email@hidden>
- Date: Fri, 24 Sep 2010 15:28:31 -0700
Some process or (more likely) some person added one or more rows to this able and did not update the sequence. It does not update automatically on insert.
Chuck
On Sep 24, 2010, at 2:06 PM, Amedeo Mantica wrote:
> It worked !
> thanks Chuck
>
> What my have caused the problem ?
>
> Amed
>
> On 24/set/2010, at 21.10, Chuck Hill wrote:
>
>> Have you tried resetting the PK sequence in FrontBase?
>>
>> SET UNIQUE FOR APProduct(<PK name>);
>>
>>
>> Chuck
>>
>> On Sep 24, 2010, at 11:12 AM, Amedeo Mantica wrote:
>>
>>> seem to be ok, but still doesn't
>>>
>>> <eo.gif>
>>> On 24/set/2010, at 20.07, Chuck Hill wrote:
>>>
>>>> It has to be your model.
>>>>
>>>>
>>>> On Sep 24, 2010, at 11:04 AM, Amedeo Mantica wrote:
>>>>
>>>>> Same error without D2W
>>>>>
>>>>> On 24/set/2010, at 19.50, Amedeo Mantica wrote:
>>>>>
>>>>>> I use always frontbase too and never happened this strange think
>>>>>> I checked the name and also copy/pasted again....
>>>>>>
>>>>>> now trying to create a component page for test without d2w
>>>>>>
>>>>>> Amedeo
>>>>>>
>>>>>> On 24/set/2010, at 19.30, Chuck Hill wrote:
>>>>>>
>>>>>>> Check that the table names are identical for all three entities. I use single table and FrontBase all the time without problem. The problem is probably in your model.
>>>>>>>
>>>>>>> Chuck
>>>>>>>
>>>>>>>
>>>>>>> On Sep 24, 2010, at 10:18 AM, Amedeo Mantica wrote:
>>>>>>>
>>>>>>>> Using FrontBase and D2W
>>>>>>>>
>>>>>>>> When I try to save It tries to store a new row with primary key conflicting to another object
>>>>>>>>
>>>>>>>> I'm using single table inheritance
>>>>>>>>
>>>>>>>> APProduct is top entity ( abstract )
>>>>>>>> APMasterSink and APSink are both childs of APProduct
>>>>>>>> Saving APSink tries to save over and APMasterSink
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>>
>>>>>>>> Amed
>>>>>>>>
>>>>>>>>
>>>>>>>> "Bundles" = {
>>>>>>>> "Ajax" = "5.0";
>>>>>>>> "ApellDataStore" = "0.0";
>>>>>>>> "JavaWebObjects" = "5.4.3";
>>>>>>>> "ERDirectToWeb" = "5.0";
>>>>>>>> "ERJars" = "5.0";
>>>>>>>> "ERAttachment" = "5.0";
>>>>>>>> "JavaJDBCAdaptor" = "5.4.3";
>>>>>>>> "JavaEOProject" = "5.4";
>>>>>>>> "JavaWOExtensions" = "5.0";
>>>>>>>> "JavaEOControl" = "5.4.2";
>>>>>>>> "ApellSkin" = "0.0";
>>>>>>>> "WOOgnl" = "5.0";
>>>>>>>> "JavaDirectToWeb" = "5.4.3";
>>>>>>>> "JavaFoundation" = "5.4.3";
>>>>>>>> "ERExtensions" = "5.0";
>>>>>>>> "ERModernDirectToWeb" = "5.0";
>>>>>>>> "InsignoWO" = "0.0";
>>>>>>>> "ERModernLook" = "5.0";
>>>>>>>> "FrontBasePlugIn" = "5.0";
>>>>>>>> "JavaEOAccess" = "5.4.3";
>>>>>>>> "JavaXML" = "5.4.2";
>>>>>>>> "Apell" = "";
>>>>>>>> "WOLips" = "5.0";
>>>>>>>> "ERPrototypes" = "5.0";
>>>>>>>> "JavaDTWGeneration" = "5.4";
>>>>>>>> };
>>>>>>>>
>>>>>>>>
>>>>>>>> EOGeneralAdaptorException: EvaluateExpression failed: <com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression: "INSERT INTO "APProduct"("isUniversal", "attachmentIDOutline", "hasTapHole", "attachmentIDLarge", "aPFittingID", "code", "type", "isLeft", "isRight", "weight", "nameEn", "nameIt", "attachmentIDIcon", "noteEn", "noteIt", "id", "aPFinishID", "aPMasterSinkID") VALUES ('false', 1000021, 'false', 1000020, 1000001, NULL, 'S', 'false', 'true', NULL, 'SubSink', 'SubLavello', 1000019, NULL, NULL, 1000004, 1000001, 1000006)" withBindings: >:
>>>>>>>> Next exception:SQL State:23 subclass = 00 -- error code: 358 -- msg: Exception condition 358. Integrity constraint violation (PRIMARY KEY, APProduct.PRIMARY_KEY_APProduct_id(id=1000004)).
>>>>>>>> Next exception:SQL State:40 subclass = 00 -- error code: 363 -- msg: Exception condition 363. Transaction rollback.
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Do not post admin requests to the list. They will be ignored.
>>>>>>>> Webobjects-dev mailing list (email@hidden)
>>>>>>>> Help/Unsubscribe/Update your Subscription:
>>>>>>>>
>>>>>>>> This email sent to email@hidden
>>>>>>>
>>>>>>> --
>>>>>>> Chuck Hill Senior Consultant / VP Development
>>>>>>>
>>>>>>> Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
>>>>>>> http://www.global-village.net/products/practical_webobjects
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Do not post admin requests to the list. They will be ignored.
>>>>>> Webobjects-dev mailing list (email@hidden)
>>>>>> Help/Unsubscribe/Update your Subscription:
>>>>>>
>>>>>> This email sent to email@hidden
>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Do not post admin requests to the list. They will be ignored.
>>>>> Webobjects-dev mailing list (email@hidden)
>>>>> Help/Unsubscribe/Update your Subscription:
>>>>>
>>>>> This email sent to email@hidden
>>>>
>>>> --
>>>> Chuck Hill Senior Consultant / VP Development
>>>>
>>>> Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
>>>> http://www.global-village.net/products/practical_webobjects
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>> --
>> Chuck Hill Senior Consultant / VP Development
>>
>> Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
>> http://www.global-village.net/products/practical_webobjects
>>
>>
>>
>>
>>
>>
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden