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 protected])
>>>>>>> Help/Unsubscribe/Update your Subscription:
>>>>>>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>>>>>>>
>>>>>>> This email sent to [email protected]
>>>>>>
>>>>>> --
>>>>>> 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 protected])
>>>>> Help/Unsubscribe/Update your Subscription:
>>>>> http://lists.apple.com/mailman/options/webobjects-dev/amedeomailing%40insigno.it
>>>>>
>>>>> This email sent to [email protected]
>>>>>
>>>>
>>>> _______________________________________________
>>>> Do not post admin requests to the list. They will be ignored.
>>>> Webobjects-dev mailing list ([email protected])
>>>> Help/Unsubscribe/Update your Subscription:
>>>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>>>>
>>>> This email sent to [email protected]
>>>
>>> --
>>> 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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
