Re: Primary Key error
Re: Primary Key error
- Subject: Re: Primary Key error
- From: Chuck Hill <email@hidden>
- Date: Fri, 24 Sep 2010 10:30:07 -0700
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
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