Re: EOF and MS SQLServer?
Re: EOF and MS SQLServer?
- Subject: Re: EOF and MS SQLServer?
- From: Chuck Hill <email@hidden>
- Date: Wed, 27 Feb 2019 09:27:22 -0800
Hi Markus,
This was back in 2008 so things may have changed. IIRC the plugin I used was
called MicrosoftPlugIn and it was part of WO. The ordering below was the main
issue that I had. The other was that timestamps were accurate to something
like 3 ms in the database so while you could use then, you could not use them
for optimistic locking as the snapshot value would often not match the value in
the generated WHERE clause.
Chuck.
> On Feb 27, 2019, at 6:52 AM, Aaron Rosenzweig <email@hidden> wrote:
>
> Hi Markus,
>
> Here’s the coordinating callback hook I was referring to (made for MS SQL but
> could work for any DB):
>
> https://github.com/wocommunity/wonder/blob/master/Frameworks/Core/ERExtensions/Sources/com/webobjects/eoaccess/ERXEntityDependencyOrderingDelegate.java
>
> <https://github.com/wocommunity/wonder/blob/master/Frameworks/Core/ERExtensions/Sources/com/webobjects/eoaccess/ERXEntityDependencyOrderingDelegate.java>
>
> It helps with, but does not fully eliminate, problems due to lack of deferred
> constraints.
> AARON ROSENZWEIG / Chat 'n Bike <http://www.chatnbike.com/>
> e: email@hidden <mailto:email@hidden> t: (301) 956-2319
>
>
>
>> On Feb 27, 2019, at 9:47 AM, Aaron Rosenzweig <email@hidden
>> <mailto:email@hidden>> wrote:
>>
>> Hi Markus,
>>
>> If memory serves, Chuck Hill deployed to MS SQLServer. I remember
>> specifically he had a coordinating callback that was added to Wonder so that
>> it did a better job of organizing the order of update/delete/insert as to
>> help not avoid constraint errors. That’s because MS SQL didn’t have deferred
>> constraints back then (maybe it does now). I thought there was a plug-in
>> too…
>> AARON ROSENZWEIG / Chat 'n Bike <http://www.chatnbike.com/>
>> e: email@hidden <mailto:email@hidden> t: (301) 956-2319
>>
>>
>>
>>> On Feb 27, 2019, at 4:40 AM, Markus Ruggiero <email@hidden
>>> <mailto:email@hidden>> wrote:
>>>
>>> We are about to get a new project but the customer requires the application
>>> to run against an existing Microsoft SQL Server (version not yet known).
>>> When I create a new EOModel there is no selection for an MS SQL Server
>>> plug-in. No support in Wonder for Microsoft?
>>>
>>> Does anyone have experience running a Wonder App against a Microssoft
>>> database?
>>>
>>> Please help and advise
>>> ---markus---
>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list (email@hidden
>>> <mailto:email@hidden>)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>>
>>> This email sent to email@hidden <mailto:email@hidden>
>>
>
> _______________________________________________
> 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
_______________________________________________
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