Re: the trouble with migrations...
Re: the trouble with migrations...
- Subject: Re: the trouble with migrations...
- From: David Avendasora <email@hidden>
- Date: Tue, 27 May 2014 17:24:10 -0400
I think part of the problem is that ERXMigrationDatabase uses the old deprecated synchronization factory stuff. Have you tried changing
public EOSynchronizationFactory synchronizationFactory() {
return (EOSynchronizationFactory) adaptor().synchronizationFactory();
}
to:
public EOSchemaSynchronizationFactory synchronizationFactory() {
return adaptor().schemaSynchronizationFactory();
}
?
There isn’t a Wonder version of the OpenBasePlugIn, but the WO 5.4.3 implementation uses the new EOSchemaSynchronizationFactory, so maybe changing that call will get it to use the one for the plugin instead of the generic one.
Dave
On May 27, 2014, at 2:23 PM, Timothy Worman <email@hidden> wrote:
> Hey Dave:
>
> I saw that you had a similar post to the list about the older deprecated API’s.
>
> Yeah, I’ve jumped in that pool - SQLHelper and all. I have a branch of Wonder that is completely updated off of the older, deprecated API’s. If you’re interested in checking it out, I can make it available on github.
>
> I’m still seeing ERXMigrationDatabase.synchronizationFactory returning a com.webobjects.eoaccess.EOSynchronizationFactory - which makes me concerned that something down deep and unreachable by me is making that happen.
>
> Curiously, this stuff is correct:
>
> expression class: com.webobjects.jdbcadaptor.OpenBasePlugIn$OpenBaseExpression
> plugin name: OpenBase
>
> I’ve been away all weekend too so I haven’t been able to look into it further. Let me know if you’d like to hammer on this thing a little.
>
> Tim
> UCLA GSE&IS
>
> On May 24, 2014, at 9:00 AM, David Avendasora <email@hidden> wrote:
>
>> Hi Tim,
>>
>> In addition to the schema synchronization stuff you also need to look at the SQLHelper subclasses defined for the plug-in.
>>
>> I believe these were created as part of Mike's original migrations implementation and it's entirely possible that there was never one created for open base and therefore it's not doing what it supposed.
>>
>> Sorry I can't be more specific right now I'm not in front of my computer, but I've been digging around down in the plug-ins and the schema synchronization code quite a bit in the last couple months so I think I'll should be able to help more once I am back at my computer. By Tuesday for sure.
>>
>> Dave
>>
>> Sent from my iPhone
>>
>>> On May 23, 2014, at 7:26 PM, Timothy Worman <email@hidden> wrote:
>>>
>>> So, I’ve been looking into a problem with ERXMigrations related to OpenBase. The SQL in migrations is wonky which was detailed here many moons ago:
>>>
>>> http://prod.lists.apple.com/archives/webobjects-dev/2008/Oct/msg00431.html
>>>
>>> Namely, the “constraints” sql-isms are different. But wait, aren’t the frameworks supposed to build SQL expressions based on the JDBC plugin you’re using (in this case OpenBasePlugIn)?
>>>
>>> I decided to mess with the OpenBase plugin source and see if I could fix this issue - maybe sth more recent in WO-ness wasn’t being properly overridden in the plugin. This is what I’ve found -
>>>
>>> ERXMigrationDatabase.synchronizationFactory() is supposed to return a database-specific subclass of EOSynchronizationFactory (if I’m not mistaken). For OpenBase this should be OpenBaseSynchronizationFactory. However, it doesn’t appear to. The first time I run my app and ERAttachment0 is called, a standard base EOSynchronizationFactory (not OpenBaseSynchronizationFactory) is returned. No code from the subclass is called.
>>>
>>> Do others using PostgreSQL or other database experience this?
>>>
>>> Bueller…….Bueller……
>>>
>>> Tim
>>> UCLA GSE&IS
>>> _______________________________________________
>>> 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
>>
>
>
>
—————————————————————————————
WebObjects - so easy that even Dave Avendasora can do it!™
—————————————————————————————
David Avendasora
Senior Software Abuser
Nekesto, Inc.
_______________________________________________
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