• 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: [Newbie] WO 5.2/mySQL/EOModeler Alert No Reason Provided
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Newbie] WO 5.2/mySQL/EOModeler Alert No Reason Provided


  • Subject: Re: [Newbie] WO 5.2/mySQL/EOModeler Alert No Reason Provided
  • From: Christian Evans <email@hidden>
  • Date: Thu, 5 Jun 2003 21:22:48 -0400

I think we are probably in a beggars situation with the freebies. However, when I synchronize, I get an error but the sync works OK. I think the issue maybe that the sync is trying to recreate foreign key constraints and MySQL 3.xx does not support foreign keys. MySQL 4.0 does but I don't want to deal with installing a new MySQL and worrying about server upgrades blowing it all away. I'm kind-of hoping Apple puts the 4.0 version in 10.3. :-)

HTH,
Christian



On Thursday, June 5, 2003, at 02:16  PM, Jess Bowers wrote:

I'm getting an oddly confusing, vague and frustrating error in EOModeler
when trying to synchronize my model with the database.


Alert : No Reason Provided.

When I delete the tables in the DB, then run Generate SQL and re-create
them, then run synchronize schema, it generally works (sometimes there are
messages, usually about the "drop constraint" -- which is confusing, since I
don't really know a lick of SQL -- isn't EO/JDBC supposed to handle this for
me?)


I guess I'm at a loss for information about *how* to solve this and other
SQL related problems with the mySQL database.


First off, is there a way to debug the JDBC connector or EOModeler's SQL
generation?


Is there a good resource for JDBC related problems (mailing list, faq, etc)?

Is there a better free DB solution for WebObjects 5.2 than mySQL?
PostgreSQL?  Or am I just in a beggars can't be choosers situation with
these free databases?

Setup details:
WO 5.2
mySQL 3.23.53
mysql-connector-java-2.0.14-bin.jar

thanks!
Jess
_______________________________________________
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: 
 >[Newbie] WO 5.2/mySQL/EOModeler Alert No Reason Provided (From: Jess Bowers <email@hidden>)

  • Prev by Date: Re: Picking up .wo changes
  • Next by Date: Re: filterArrayWithQualifier: how do i set a fetch for timestamp for one day?
  • Previous by thread: Re: [Newbie] WO 5.2/mySQL/EOModeler Alert No Reason Provided
  • Next by thread: filterArrayWithQualifier: how do i set a fetch for timestamp for one day?
  • Index(es):
    • Date
    • Thread