O:-)
On 25/set/2010, at 00.28, Chuck Hill wrote:
> 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 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/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/archive%40mail-archive.com
This email sent to [email protected]
