FW: MySQL
FW: MySQL
- Subject: FW: MySQL
- From: "John Martyniak" <email@hidden>
- Date: Wed, 7 May 2003 23:51:14 -0400
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.