Re: EOModeler error with MySQL - SOLVED
Re: EOModeler error with MySQL - SOLVED
- Subject: Re: EOModeler error with MySQL - SOLVED
- From: Riccardo De Menna <email@hidden>
- Date: Wed, 9 Jul 2003 11:17:18 +0200
Again to all,
I post some other inconsistent behavior with MySQL using
mysql-connector as driver.
1. The 'capitalizeTypeNames' option for the jdbc driver doesn't seem to
work correctly or at least EOModeler ignores it. If you have col types
in uppercase, it will always try to rebuild everything regardless of
the capitalize setting. Apparently, setting the option to FALSE and
putting all the type names in lower case, fixes the problem and
EOModeler will not try to drop all the tables but will correctly
understand when the schema is in sync.
2. This is strange... If you have a many-to-many relationship through
a correlation table, you will probably experience this. I really don't
know why, but it seams that if you have a table with ONLY indexed
columns (like a typical correlation table with only two indexes
referring two the two other tables), EOModeler gets crazy and starts
giving you those annoying "Alert: no reason provided" msg's. If you
simply add any NON indexed column in the table (I called mine dummy and
it was char(2)), voil`!!! everything start's working again.
Has anyone any idea of what could be the reason for this latter one?
I'm no db expert and even checking the query log of the mysql server
didn't give me any clues. The solution shown works for me, but the idea
of having to put a dummy col in every correlation table seams
ridiculous.
Regards,
Riccardo De Menna
On Monday, July 7, 2003, at 02:28 PM, Riccardo De Menna wrote:
Hi all,
I reply to myself since I found what was the problem with the
EOModeler - MySQL pair and it might be useful to others.
It looks like it was something to do with the privileges of the
Developer Directory. Most files there have privs 775 and if you run
them as an admin user you won't get any problems.
In my setup, I had an XServe working as an application server and thus
the users had only read-execute on some files and nothing on others
(that was probably the problem).
I've chmod to 775 the whole directory and now the problem is gone.
I just wonder why this thing happened only for mysql and not openbase,
but if you run into the same thing, just try fiddling with your
privileges and it might solve the problem.
Regards,
Riccardo De Menna
On Friday, July 4, 2003, at 11:22 AM, Riccardo De Menna wrote:
Hi,
Has anybody experienced (and hopefully found a solution) an 'Alert:
No Reason Provided' with EOModeler and MySQL when trying to
synchronize a db schema?
I've tried mysql-connector versions 2.0.14 , 3.0.8 stable and 3.1.0
alpha, with both mysqld v.3.x and now also 4.x on OS X Server.
I've also played with some of the inline parameters in the connection
uri like: autoReconnect, capitalizeTypeNames etc
The alert comes out before the sync window, so I suppose it has to do
with the JDBC driver. Also, the 'Generate SQL' part works great (but
erases all my data)... only sync gives problems. If I revert to
OpenBase it works great. Updating all the models by hand is something
I would like to avoid if possible :-)
Any clues? Is there any other mysql-jdbc driver I could use that
seams to work well?
I can't believe no one uses mysql with webobjects so it MUST be that
I'm doing something wrong, but I just can't figure out what?
Any help is greatly appreciated.
Warm Regards,
Riccardo De Menna
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.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/Archives:
http://www.lists.apple.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/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.