Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: Stupid Person Question - Mysql Relationships

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Stupid Person Question - Mysql Relationships

Subject: Re: Stupid Person Question - Mysql Relationships
From: Kieran Kelleher <email@hidden>
Date: Wed, 10 Aug 2005 12:31:01 -0400

FYI,

Another point that might be related to this behaviour for MySQL

I have found that foreign keys that NOT NULL can sometimes cause failure in validateForSave since the corresponding primary keys have not been propogated yet.

In any case, the solution that works best for me is to check the Allow Null property for the foreign key attribute in EOModeler and in the DB, have the foreign key as NOT NULL

Regards, Kieran

On Aug 10, 2005, at 10:08 AM, Zak Burke wrote:

Tony Hoffman wrote on 8/9/05 11:42 PM:
My question is basically this: does anybody know how to use Mysql
4.1.1.12 and EOModeler together so that foreign key relationships can
be happily generated / synchronized into the database?
I know that the Mysql database has to be stored as an InnoDB
[...]
As an aside to the discussion about synchronization specifically, note
that EOF and MySQL constraints do not play nice together with the
following set up:
	MacOS 10.3.9
	WO 5.2.3
	MySQL 4.1.7
	mysql-connector-java-3.0.10-stable-bin.jar
See this post (and my follow-up correction) for the details: http://www.omnigroup.com/mailman/archive/webobjects-dev/2005-August/ 006118.html

The short story is that EOF does not attempt to sort insert or delete operations to satisfy foreign key constraints, but deferring constraints around transactions causes primary key selection from EO_PK_TABLE to fail.
I don't know if these issues are resolved in MySQL 4.1.1.2, MacOS 10.4
or WO 5.3.
Best,
zak.
_______________________________________________
WebObjects-dev mailing list
email@hidden
http://www.omnigroup.com/mailman/listinfo/webobjects-dev


_______________________________________________
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



Prev by Date:
Re: Using LIKE with PostgreSQL

Next by Date:
Re: Using LIKE with PostgreSQL

Previous by thread:
Re: WebObjects with JBoss deployment

Next by thread:
Optimization - Share All Objects -> Register Database Context?

Index(es):

Date
Thread