I think I have tracked down the problem (that was causing the
problem
with horizontal inheritance). Primary key's don't seem to be
getting
set correctly when using the latest MySQL and WebObjects.
EOF creates the eo_pk_table ok and tracks the primary key values ok,
but when it writes new records to tables, EOF doesn't seem to write
the primary key value.
Hence, all primary key values are set to 0, or at least the first
one
is, the second attempt to add a new row fails because the primary
key
is the same.
This is the sort of error I am getting:
com.webobjects.eoaccess.EOGeneralAdaptorException:
EvaluateExpression
failed: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression:
"INSERT INTO sdclient(sdcountry, sdemailaddress, sdstreetaddress,
sdfaxnumber, sdphonenumber, sdclientcode, sdpostaladdress, sdname,
sdpostcode, sdstate) VALUES (NULL, NULL, ?, NULL, NULL, ?, NULL, ?,
NULL, NULL)" withBindings: 1:"B"(streetAddress), 2:"B"(clientCode),
3:"B"(name)>:
Next exception:SQL State:S1009 -- error code: 1062 -- msg:
Invalid
argument value, message from server: "Duplicate entry '0' for
key 1"
Note, EOF does not seem to be writing the column "sdclientpk" even
though it is a part of the model, and it is set at the primary
key for
that table.
Any ideas, suggestions, obvious errors, most appreciated.
Cheers,
Ashley.