There is also no row locking on EO_PK_TABLE with myisam, so you will get primary key clashes and subsequent failed inserts if the db is sufficiently contended.
On 31/10/2012, at 12:03 AM, Kieran Kelleher <[email protected]> wrote: > So, it might be stating the obvious, but the primary consequence of using a > non-transactional database such as MyISAM with WebObjects is that a failed > EOEditingContext.saveChanges() will not be rolled back in the database which > causes the unsaved EC changes to be actually *partially* saved resulting in > inconsistent data, orphan records, relationships pointing to objects that > don't exist, etc. and the most common error thrown by your app will become > EOObjectNotAvailableException .... basically chaos and corrupt useless data > because you shot yourself in the foot over and over :) > > On Oct 29, 2012, at 7:23 PM, Ramsey Gurley <[email protected]> wrote: > >> MyISAM is not ACID. WO was designed around the concept of ACID transactions >> with highly consistent data. >> >> http://www.julianbrowne.com/article/viewer/brewers-cap-theorem >> >> Ramsey >> >> On Oct 29, 2012, at 3:09 PM, Gino Pacitti wrote: >> >>> Hi list >>> >>> I read in the wiki a reference to WO not using MyISAM in tables but no >>> explanation why - any pointers to an explanation. >>> >>> Gino >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com >>> >>> This email sent to [email protected] >> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com >> >> This email sent to [email protected] > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/qdolan%40gmail.com > > This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
