Solved: MySQL problem ...

"Ashley Aitken" <[email protected]> Sat, 03 Apr 2004 23:17:41 +0800
Newsgroups gmane.comp.web.webobjects.eof
Message-ID <[email protected]>
Howdy All,

I just wanted to report that I have solved the basic problem I was
having with MySQL (which I believe was causing the problems with
horizontal inheritance and primary key generation).

It turns out that the EOPrototypes I was using had an entry named "oid"
for primary keys that had READ ONLY set to true. 

I guess I can understand why one would want primary keys to be read-only
(in a sense) but it seemed to cause problems with the current
configuration of tools.

Basically, EOF chose not to write the primary key for rows (because it
was read only).

I'll contact the provider of these MySQL EOPrototypes directly to
discuss the issue, but beware if you download some MySQL EOPrototypes
that contain the prototype "oid" set to read-only.

Thanks to all those who provided assitance in tracking down this
problem.

So, it seems (so far at least) MySQL and WO do work together well.

Cheers,
Ashley Aitken.