Re: [Wonder-disc] EO model validation with Wonder and foreign keys

From: Zak Burke (zdbw..artmouth.EDU)
Date: Tue Dec 12 2006 - 20:20:45 EST

  • Next message: Pierre Frisch: "Classpath issue."

    Chuck Hill wrote on 12/12/06 7:59 PM:
    >
    > On Dec 12, 2006, at 4:32 PM, Zak Burke wrote:
    >
    >> I thought I would bite the bullet and install Wonder, to see if it made
    >> all my EO Model/Entity Modeler validation issues magically disappear.
    >> I've written about this problem before but was never able to resolve it.
    >> Here it is, in a nutshell: When an EO has a required relation, Entity
    >> Modeler complains if the EO's foreign key is not also marked as
    >> required. EOF, however, chokes when the foreign key is required because
    >> it handles validation before a new related object has been persisted,
    >> and therefore has no foreign key to assign.
    >
    > You sure that is EOF choking, not the database? Sometimes EOF orders
    > operations in a, er, unfortunate order. If your database supports its,
    > the solution is to mark the FK constraints as DEFERRABLE INITIALLY
    > DEFERRED.

    Yup, I'm sure. This column of the DB is unconstrained specifically to
    avoid this problem.

    zak.



    This archive was generated by hypermail 2.0.0 : Tue Dec 12 2006 - 20:21:05 EST