We ended up having to not use database level constraints to support SQL
server - our relationships seemed to be too complex to try to order
manually. It would be nice to have deferrable constraints like Oracle
Dov
On 11/6/09 1:43 PM, "David Avendasora" <email@hidden> 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.
>
> 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:
>> http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora
>> .com
>>
>> 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/Refer
> ence/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:
> http://lists.apple.com/mailman/options/webobjects-dev/email@hidden
>
> 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:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden
This email sent to email@hidden
