RE: MySQL
RE: MySQL
- Subject: RE: MySQL
- From: "Kieran Kelleher" <email@hidden>
- Date: Thu, 8 May 2003 14:08:39 -0400
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.
- Follow-Ups:
- RE: MySQL
- From: "John Martyniak" <email@hidden>
| References: | |
| | >FW: MySQL (From: "John Martyniak" <email@hidden>) |