Apple

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.