Re: FW: MySQL
Re: FW: MySQL
- Subject: Re: FW: MySQL
- From: Art Isbell <email@hidden>
- Date: Wed, 7 May 2003 18:13:27 -1000
On Wednesday, May 7, 2003, at 05:51 PM, John Martyniak wrote:
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.
EOUtilities.objectsMatchingKeyAndValue() and
EOUtilities.objectsWithFetchSpecificationAndBindings() are both
convenience methods that invoke
EOEditingContext.objectsWithFetchSpecification(). So the generated SQL
should be identical for identical keys and values.
I'm not certain what you mean when you say you "run with Debug", but
if you set a launch argument of "-EOAdaptorDebugEnabled true", you
should see the SQL that's being sent to MySQL.
1) do I need to make sure that the table is transaction enabled
(INNODB), currently they are not.
I know nothing about MySQL, but EOF can generate multiple SQL
statements that are in the same transaction such that if an error
occurs, the entire transaction can be rolled back. So I would say that
transactions should be enabled.
3) Is there something that I should make sure is in my code for
this
to work properly with MySQL.
EOF is database-independent as long as you don't send raw SQL from
EOF. So you shouldn't have to code specifically for MySQL.
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: | |
| | >FW: MySQL (From: "John Martyniak" <email@hidden>) |