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







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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to