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
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]
