• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: EOModeler error with MySQL - SOLVED
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

References: 
 >Re: EOModeler error with MySQL - SOLVED (From: Riccardo De Menna <email@hidden>)

  • Prev by Date: Re: External Command Call [ LATEST ] - More Java Than WebObjects
  • Next by Date: Re: how to set the "CLASSPATH environment variable"
  • Previous by thread: Re: EOModeler error with MySQL - SOLVED
  • Next by thread: wotaskd and WOSMTPHost
  • Index(es):
    • Date
    • Thread