RE: MySQL
RE: MySQL
- Subject: RE: MySQL
- From: "John Martyniak" <email@hidden>
- Date: Thu, 8 May 2003 18:21:43 -0400
To Everyone,
Thanks for all of the response so far. 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.
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.
I think that the issue has something to do with Snapshot maybe, or some
other direct component. I am going to further simplify my test case and
see if I can get to the root of the problem.
Does anybody know if 5.2 has better support for MySQL?
-John
Avum, Inc.
http://www.avum.com
-----Original Message-----
From: email@hidden
[mailto:email@hidden] On Behalf Of Kieran
Kelleher
Sent: Thursday, May 08, 2003 2:09 PM
To: 'John Martyniak'; email@hidden
Subject: RE: MySQL
John,
I am new to MySQL, but from what I have learned, INNODB table
formats are
not available in the version 3.23 standard 'mysqld' configuration or
even
the 'mysqld-nt' engine (default Windows configuration). The 'mysqld-max'
configuration installation of 3.23 is required if you want
transaction-based
InnoDB tables. See this link...
http://www.mysql.com/doc/en/mysqld-max.html
* NOTE *: Since MySQL 3.23 is the 'official' supported version for
WebObject
5.1 or 5.2 (see link...
http://docs.info.apple.com/article.html?artnum=72598
... and since the standard installation does not by default support
InnoDB
and therefore transactions, then
it is reasonable to expect that WebObjects is not sending transaction
wrapped SQL to MySQL 3.23 since it does not support it.
MySQL 4.0 does by default support InnoDB and transactions. When you see
a WO
update that officially supports this version, then maybe the EO
framework
will use SQL transactions for updates.
--Kieran
-----Original Message-----
From: email@hidden
[mailto:email@hidden]On Behalf Of John Martyniak
Sent: Wednesday, May 07, 2003 11:51 PM
To: email@hidden
Subject: FW: MySQL
Hi everyone,
I am running Windows 2000, Webobjects 5.1 (Preparing to upgrade to
5.1.3), I am using the MYSQL 2.0.14 driver, and MySQL 3.23.56.
Okay so I have set everything up. It seems to work, I have created my
models in EOModeler and built the tables in the DB, and have populated
them with Data. But I have a problem.
When I do a objectsMatchingKeyAndValue I get my EO back I am able to
change a property in the EO and save the changes and everything works
great (also when I run with Debug, this does a regular 'select').
When I run the objectsWithFetchSpecificationAndBindings I don't get any
data back, this uses a 'select . for update'. If I take that select and
run directly on the mysql db it returns results, it basically works ok.
I am a little confused.
1) do I need to make sure that the table is transaction enabled
(INNODB), currently they are not.
2) I am running the correct mix of MySQL both DB and Interface.
3) Is there something that I should make sure is in my code for this
to work properly with MySQL.
Any help would be greatly appreciated.
My next step is to rip all of the code out and try a simple test case
and see what happens. I have stepped through the code numerous times
and have been unable to find a specific issue, doesn't mean that one
doesn't exist though.
Thank you in advance,
-John
Avum, inc.
http://www.avum.com <http://www.avum.com/>
_______________________________________________
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: MySQL (From: "Kieran Kelleher" <email@hidden>) |