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: Ramsey Lee Gurley <email@hidden>
- Date: Sat, 05 Dec 2009 09:08:46 -0500
- Sun-java-system-smtp-warning: Lines longer than SMTP allows found and wrapped.
On Dec 5, 2009, at 1:40 AM, Lachlan Deck wrote:
> 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?
It exists because there's no way to run migrations for ERAttachment in 5.4.x without it. It's modeled after the Wonder plugins, so it does the automatic loading and the jdbcInfo thing the others do too. I was going to repair the inheritance problems, try to find a way to do case insensitive searches without using UPPER, add indexing support, and a few other things, but after discovering that problem is due to the database, I'll probably just look for an alternative db (^_^) The plugin is freely available here if you're interested in it.
https://r2d2w.svn.sourceforge.net/svnroot/r2d2w/trunk/
Ramsey
>
> with regards,
> --
>
> Lachlan Deck
>
>
>
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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