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 <li...@thetimmy.com> 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 <hill.ch...@gmail.com >> <mailto:hill.ch...@gmail.com>> 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 <aa...@chatnbike.com >>> <mailto:aa...@chatnbike.com>> 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: aa...@chatnbike.com <mailto:aa...@chatnbike.com> t: (301) 956-2319 >>> >>> >>>> On Feb 27, 2019, at 9:47 AM, Aaron Rosenzweig <aa...@chatnbike.com >>>> <mailto:aa...@chatnbike.com>> 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: aa...@chatnbike.com <mailto:aa...@chatnbike.com> t: (301) 956-2319 >>>> >>>> >>>>> On Feb 27, 2019, at 4:40 AM, Markus Ruggiero <mailingli...@kataputt.com >>>>> <mailto:mailingli...@kataputt.com>> 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 (Webobjects-dev@lists.apple.com >>>>> <mailto:Webobjects-dev@lists.apple.com>) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com >>>>> >>>>> <https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com> >>>>> >>>>> This email sent to aa...@chatnbike.com <mailto:aa...@chatnbike.com> >>>> >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com >>> <mailto:Webobjects-dev@lists.apple.com>) >>> Help/Unsubscribe/Update your Subscription: >>> https://lists.apple.com/mailman/options/webobjects-dev/hill.chuck%40gmail.com >>> >>> <https://lists.apple.com/mailman/options/webobjects-dev/hill.chuck%40gmail.com> >>> >>> This email sent to hill.ch...@gmail.com <mailto:hill.ch...@gmail.com> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com >> <mailto:Webobjects-dev@lists.apple.com>) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com >> <https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com> >> >> This email sent to li...@thetimmy.com <mailto:li...@thetimmy.com> > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/hugi%40karlmenn.is > > This email sent to h...@karlmenn.is
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
