Re: MS SQL Server Compatability?
Re: MS SQL Server Compatability?
- Subject: Re: MS SQL Server Compatability?
- From: Kieran Kelleher <email@hidden>
- Date: Fri, 6 Nov 2009 14:28:25 -0500
Thanks all for the great info. I must say, I really feel excited (not)
about the chance of working with MS SQL Server. It will probably be a
read-only app for querying, reporting and secure internet database
access from anywhere.
-Kieran :-)
On Nov 6, 2009, at 2:08 PM, Chuck Hill wrote:
On Nov 6, 2009, at 10:43 AM, David Avendasora wrote:
Hey Kieran,
I used MS SQL Server 2000 extensively with my WO 5.3/5.4 ERP
project - and tested it some with 2005 but never used it in
production. The biggest problem with it is that you can't defer
constraints, so if you have DB constraints, you MUST use chuck's
MSSQL plugin so that it will order the inserts, updates and deletes
based on dependencies.
The plugin works great, except for situations where a table is self-
referencing with a constraint. EOF has no way of knowing which
object it should insert first. Chuck and I discussed this situation
and I think I figured out how it _could_ be done by evaluating FKs
and PKs upon insert in self-referencing situations, but we only
ever discussed the concept. I ended up just removing the constraint
in the DB.
Also, I believe there was some weirdness related to Vertical
Inheritance, but I can't remember now as I eventually ripped it out
of my app altogether. But that weirdness could have also been
related to D2JC... not sure anymore.
Other than that, it worked fine.
Eeeew. There were some more issues that I ran into. IIRC it does
not understand (or not correctly) LIMIT expressions so the
ERXBatchingDisplayGroup won't work. If you are planning on
inserting data, be aware that the other package probably uses the
identity columns (or whatever they call their technology to create a
PK on insert) which does not play nice with EOF. DB admin is a lot
slower than with FrontBase, for example. And you need a Windows
machine / VM. If you are doing a fixed bid, I'd add 10-20% to cover
any gotchas.
Chuck
On Nov 6, 2009, at 1:30 PM, Kieran Kelleher wrote:
I am discussing a possible project with a company that uses MS SQL
Server for an existing ERP system. They are checking what version.
Can anyone tell me what versions of MS Sql Server work with WO
5.3.3? .... WO 5.4.3? ... and with latest Wonder of course?
Regards, Kieran
_______________________________________________
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
David Avendasora
Senior Software Engineer
K12, Inc.
*****
WebObjects Documentation Wiki : http://wiki.objectstyle.org/confluence/display/WO/
*****
WebObjects API: http://developer.apple.com/legacy/mac/library/documentation/MacOSXServer/Reference/WO54_Reference/index.html
*****
_______________________________________________
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
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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