First nightmare with WO inheritance after lots of [prior] success..
First nightmare with WO inheritance after lots of [prior] success..
- Subject: First nightmare with WO inheritance after lots of [prior] success..
- From: Mark Wardle <email@hidden>
- Date: Sat, 20 Nov 2010 22:13:07 +0000
Dear all,
[ Using Wonder with WO54 and PostgreSQL. ]
Is it appropriate to remove foreign key constraints when you get into hairy and complex webobjects inheritance?
I have an abstract entity Form with many subentities using horizontal inheritance.
This has worked perfectly and I have subentities representing various structured and unstructured data collection forms as well as medical investigation results.
I also have an abstract entity Annotation and a number of concrete subentities to add additional optional data to a form.
There is a to-many relationship between the abstract entity Form (db table: t_form) and the abstract entity Annotation (db table: t_annotation). There is logic to create concrete instances of subentities of the correct type and link appropriate annotation subentities to the appropriate form subentity.
I keep getting exceptions due to foreign key constraints. I suspect my solution is to remove these but I had assumed there would be some magic going on within EOF to handle this. I *thought* the topmost entity's primary key sequence generator would be used for all subentities?
EOEditingContext ec = ERXEC.newEditingContext();
Patient pt = Patient.fetchPatient(ec, Patient.PATIENT_IDENTIFIER.eq(7271L));
NSArray<Encounter> encounters = pt.encounters(null, Encounter.DATE_TIME.descs(), false);
Encounter e = encounters.get(0);
FormResultMriBrain fr = (FormResultMriBrain) EOUtilities.createAndInsertInstance(ec, FormResultMriBrain.ENTITY_NAME);
fr.setUser(User.fetchRequiredUser(ec, User.USERNAME_KEY, "mark"));
fr.setDatePerformed(new NSTimestamp());
fr.setDateReported(new NSTimestamp());
fr.setReport("A normal scan");
e.addToForms(fr);
AnnotationMriBrainAtaxia ataxia = (AnnotationMriBrainAtaxia) EOUtilities.createAndInsertInstance(ec, AnnotationMriBrainAtaxia.ENTITY_NAME);
ataxia.setForm(fr);
ataxia.setDateCreated(new NSTimestamp());
ataxia.setCerebellarAtrophy(false);
ataxia.setCerebralAtrophy(false);
ataxia.setLeucodystrophy(false);
ataxia.setPontineAtrophy(false);
ataxia.setUser(fr.user());
AnnotationMriBrainMultipleSclerosis annotation = (AnnotationMriBrainMultipleSclerosis) EOUtilities.createAndInsertInstance(ec, AnnotationMriBrainMultipleSclerosis.ENTITY_NAME);
annotation.setForm(fr);
annotation.setUser(fr.user());
ec.saveChanges();
And this is my log file: [apologies for the terribly long entity and table names]
Nov 20 21:59:49 RSNews[52700] DEBUG com.eldrix.rsdb.model._Form - updating dateCreated from null to 2010-11-20 21:59:49 Etc/GMT
Nov 20 21:59:49 RSNews[52700] DEBUG com.eldrix.rsdb.model._FormResult - updating dataSourceType from null to MANUAL
Nov 20 21:59:49 RSNews[52700] DEBUG com.eldrix.rsdb.model._FormResultMriBrain - updating withGadolinium from null to false
Nov 20 21:59:49 RSNews[52700] DEBUG com.eldrix.rsdb.model._FormResult - updating datePerformed from null to 2010-11-20 21:59:49 Etc/GMT
Nov 20 21:59:49 RSNews[52700] DEBUG com.eldrix.rsdb.model._FormResult - updating dateReported from null to 2010-11-20 21:59:49 Etc/GMT
Nov 20 21:59:49 RSNews[52700] DEBUG com.eldrix.rsdb.model._FormResultMriBrain - updating report from null to A normal scan
Nov 20 21:59:50 RSNews[52700] DEBUG com.eldrix.rsdb.model._Annotation - updating dateCreated from null to 2010-11-20 21:59:50 Etc/GMT
Nov 20 21:59:50 RSNews[52700] DEBUG com.eldrix.rsdb.model._AnnotationMriBrainAtaxia - updating cerebellarAtrophy from null to false
Nov 20 21:59:50 RSNews[52700] DEBUG com.eldrix.rsdb.model._AnnotationMriBrainAtaxia - updating cerebralAtrophy from null to false
Nov 20 21:59:50 RSNews[52700] DEBUG com.eldrix.rsdb.model._AnnotationMriBrainAtaxia - updating leucodystrophy from null to false
Nov 20 21:59:50 RSNews[52700] DEBUG com.eldrix.rsdb.model._AnnotationMriBrainAtaxia - updating pontineAtrophy from null to false
Nov 20 21:59:50 RSNews[52700] DEBUG er.eo.ERXGenericRecord - EditingContextWillSaveChanges: done calling will*
Nov 20 21:59:50 RSNews[52700] WARN NSLog - A fatal exception occurred: ERROR: insert or update on table "t_annotation_mri_brain_ataxia" violates foreign key constraint "t_annotation_mri_brain_ataxia_form_fk_id_fk"
Detail: Key (form_fk)=(29) is not present in table "t_form".
[2010-11-20 21:59:50 GMT] <main> ERROR: insert or update on table "t_annotation_mri_brain_ataxia" violates foreign key constraint "t_annotation_mri_brain_ataxia_form_fk_id_fk"
Detail: Key (form_fk)=(29) is not present in table "t_form".at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:671)
at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:691)
at com.webobjects.jdbcadaptor.JDBCContext.commitTransaction(JDBCContext.java:452)
at com.webobjects.eoaccess.EODatabaseContext.commitChanges(EODatabaseContext.java:6303)
at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:386)
at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192)
at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1085)
at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1007)
at com.eldrix.news.app.Application.<init>(Application.java:83)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:355)
at java.lang.Class.newInstance(Class.java:308)
at com.webobjects.appserver.WOApplication.main(WOApplication.java:547)
at er.extensions.appserver.ERXApplication.main(ERXApplication.java:783)
at com.eldrix.news.app.Application.main(Application.java:41)
at com.webobjects.jdbcadaptor.JDBCContext.commitTransaction(JDBCContext.java:455)
at com.webobjects.eoaccess.EODatabaseContext.commitChanges(EODatabaseContext.java:6303)
at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:386)
at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192)
at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1085)
at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1007)
at com.eldrix.news.app.Application.<init>(Application.java:83)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:355)
at java.lang.Class.newInstance(Class.java:308)
at com.webobjects.appserver.WOApplication.main(WOApplication.java:547)
at er.extensions.appserver.ERXApplication.main(ERXApplication.java:783)
at com.eldrix.news.app.Application.main(Application.java:41)
_______________________________________________
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