Re: First nightmare with WO inheritance after lots of [prior] success..
Re: First nightmare with WO inheritance after lots of [prior] success..
- Subject: Re: First nightmare with WO inheritance after lots of [prior] success..
- From: Chuck Hill <email@hidden>
- Date: Sat, 20 Nov 2010 14:55:17 -0800
Yes, database level foreign key constraints are not compatible with horizontal inheritance. They do work with single table inheritance. I prefer Single Table over Vertical or Horizontal unless I have a specific need for them. It is more efficient and has few issues. It does bother people who value idealistic schemas over efficiency and functionality. :-)
Chuck
On Nov 20, 2010, at 2:45 PM, Mark Wardle wrote:
> I think i'm being dim. I'll simply remove the db level constraints and hope EOF keeps everything rational.
>
> Mark
>
> --
> Dr. Mark Wardle
> Specialist registrar, Neurology
> (Sent from my mobile)
>
>
> On 20 Nov 2010, at 22:13, Mark Wardle <email@hidden> wrote:
>
>> 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
--
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