Re: MySQL
Re: MySQL
- Subject: Re: MySQL
- From: Art Isbell <email@hidden>
- Date: Thu, 8 May 2003 12:48:38 -1000
On Thursday, May 8, 2003, at 12:21 PM, John Martyniak wrote:
I have a little more to add, it
doesn't seem to have anything to do with the SQL. Because the first
time that I start the application it seems to do the fetch properly and
brings back the EO as expected. However, when I run the fetch a second
time it doesn't return any results.
Is the SQL being generated by EOF identical in both instances?
Also I invalidate all of the objects and I clear the object store with
the following:
editingContext.undoManager().removeAllActions();
editingContext.rootObjectStore().invalidateAllObjects();
To make sure that all of the items are invalidated and cleared so the
fetch goes against the DB every time.
In a test app, invalidateAllObjects() is fine, but it's probably not
something that you should do in a real app.
I think that the issue has something to do with Snapshot maybe, or some
other direct component.
But there should be no snapshots after
editingContext.rootObjectStore().invalidateAllObjects(). Even if a
snapshot for an object exists, objectsWithFetchSpecification() will
fetch the object from the DB. But if the fetch spec isn't set to
refresh refetched objects, the fetched object will be discarded.
Does anybody know if 5.2 has better support for MySQL?
According to http://docs.info.apple.com/article2.html?artnum=72598:
WO 5.2 is supported with MySQL 3.23.51, driver MySQLConnector/J 2
2.0.14;
WO 5.1 is supported with MySQL 3.23.42 with 2.0.6 driver.
EOF doesn't support any particular DB, just JDBC. So the better
question might be, "Does anyone know which MySQL database and driver
works best with EOF's JDBC?".
Aloha,
Art
_______________________________________________
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: MySQL (From: "John Martyniak" <email@hidden>) |