Re: Disable constraint checking under H2
Re: Disable constraint checking under H2
- Subject: Re: Disable constraint checking under H2
- From: Chuck Hill <email@hidden>
- Date: Tue, 19 Mar 2013 21:19:07 -0700
David Avendasora had an improved delegate that I think he mentioned committing to Wonder. Maybe he has not gotten around to it? Logically, you can't have mandatory circular relationships without deferred constraint handling.
David?
Chuck
On 2013-03-19, at 9:05 PM, Paul Hoadley wrote:
> 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?
>
>
> --
> Paul Hoadley
> http://logicsquad.net/
>
>
>
> _______________________________________________
> 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
Executive Managing Partner, VP Development and Technical Services
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/gvc/practical_webobjects
Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing Companies in B.C!
Global Village Consulting ranks 76th in 24th annual PROFIT 200 ranking of Canada’s Fastest-Growing Companies by PROFIT Magazine!
_______________________________________________
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