whoa! unexpected can-o-worms! I guess I had been using FrontBase...But now I'm on mysql via amazon RDS which really seems like a nice service.
I really could care less about how keys are constrained really, I have a new WO-centric data model and WO is the main handler of the data and this is a new setup, so the path of greatest WO'ness is the clear choice. > 1. The FK and the ID it's pointing to are the same field types. well, they really do all seem to be properly inheriting from ID prototype and aside from being marked as non-required and I guess I turned off locking for that property...the ER tables are getting created from scratch at the same time etc. > 2. (Most likely) the table must be InnoDB, not MyISAM. MyISAM does not > support FK constraints. the tables do seem to be inoDB (whatever that is) and utf-8 in the hope of capturing various languages properly. I wonder this - I have at least one table that I was using that is a correlation table (invitation) and the eogen makes key constraints for that table -- the trouble comes for me when I connect to the ERAttachemnt model. NOW -- I did have some trouble with that relationship while getting started, I know I had to delete a framework I had somehow imported and changed in order to get it in sync with the deployment model which I bundle up with the app. (I'm also new to eclipse) I really thought I had a model confusion going on...something stemming from that duplicate model or something. Also note -- I have been able to upload photos while I've been dropping and recreating tables and model files and testing things. If I recall, I opted out of the egoen'd key constraint and some point and was able to store attachments without the error message at runtime - but it has been inconsistent and of course, if I could recall the recipe and it worked, I'd just stick with it. Thoughts? Should I opt away from constraints anyway? Model setting I should try? _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
