Re: MS SQL Server Compatability?
Re: MS SQL Server Compatability?
- Subject: Re: MS SQL Server Compatability?
- From: David Avendasora <email@hidden>
- Date: Fri, 6 Nov 2009 13:43:47 -0500
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.
Dave
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