Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]
Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]
- Subject: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]
- From: Lachlan Deck <email@hidden>
- Date: Sat, 5 Dec 2009 17:40:38 +1100
On 05/12/2009, at 12:02 AM, Ramsey Lee Gurley wrote:
> Hi Kieran,
>
> Have you tried vertical inheritance with MySQL?
He wouldn't have. I have and continue to.
> I have Animal->Cat->Leopard. I try to create a leopard and it fails because
>
> com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "INSERT INTO Leopard(spots, id) VALUES (?, ?)" withBindings: 1:33(spots), 2:9(id)>:
> Next exception:SQL State:23000 -- error code: 1452 -- msg: Cannot add or update a child row: a foreign key constraint fails (`example/leopard`, CONSTRAINT `Leopard_id_id_FK` FOREIGN KEY (`id`) REFERENCES `cat` (`id`))
Yep. I've avoided using fk constraints since mysql doesn't play nice with this.
> It gets the adaptor operations for Animal, then Leopard, then Cat... and blows up at leopard because there's no cat yet (I think). I had to google for "What are deferred constraints" so I could be very wrong, but I think it's blowing up because of lack of deferred constraints (^_^) It looks like I'll need to have an EODatabaseContext delegate override databaseContextWillOrderAdaptorOperations to fix it, unless there is something in the ERXSQLHelper that can get there first.
>
> This just happens to be a timely thread since I was messing with my MySQLPlugin last night (^_^)
What does your plugin do?
with regards,
--
Lachlan Deck
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden