Re: EOF and MS SQLServer?
Re: EOF and MS SQLServer?
- Subject: Re: EOF and MS SQLServer?
- From: Hugi Thordarson <email@hidden>
- Date: Wed, 27 Feb 2019 23:22:47 +0000
Used EOF with MS SQL Server a lot about a decade ago, worked fine and I don't
recall a lot of caveats. All switched to Cayenne now, though.
- hugi
> On 27 Feb 2019, at 19:00, Tim Worman <email@hidden> wrote:
>
> Hi Markus,
>
> I’ve used the Microsoft plugin in Wonder to connect to SQL Server quite a
> lot. I don’t have to write data to these databases so I can’t offer any
> updates on the issues Chuck encountered but our connections have worked well.
> There are definitely peculiarities working SQL Server though and I’m happy to
> chime in if/when you see issues.
>
> <PastedGraphic-1.png>
>
> Tim
> UCLA GSE&IS
>
>> On Feb 27, 2019, at 9:27 AM, Chuck Hill <email@hidden
>> <mailto:email@hidden>> wrote:
>>
>> 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
>>> <mailto: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
>>> <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
>> <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