Disable constraint checking under H2
Disable constraint checking under H2
- Subject: Disable constraint checking under H2
- From: Paul Hoadley <email@hidden>
- Date: Wed, 20 Mar 2013 14:35:07 +1030
| Hello,
In production we use PostgreSQL, but I am investigating the possibility of running functional tests (using Selenium WebDriver) during continuous integration, so I'm looking at getting a particular application running with H2. H2 doesn't support deferred constraints, and it doesn't take very long for that to become an issue. I've tried using ERXEntityDependencyOrderingDelegate, but it bailed out because of a circular reference in a model. As an aside, it's complaining about an optional circular reference (where every Person has an Organisation, and Organisations have an optional 'creator' pointing back to Person)—it's certainly _right_, but I dug up a thread where someone seemed to be suggesting that _optional_ relationships wouldn't be a problem. Maybe it needs to be optional in both directions.
In any case, I'm slightly stuck. Before I start looking at H2's "SET REFERENTIAL_INTEGRITY FALSE" statement, can anyone suggest a more subtle workaround for this?
|
_______________________________________________
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