Re: DB2 and WebObjects

2008-04-07 Thread Chuck Hill
On Apr 7, 2008, at 2:19 AM, David Avendasora wrote: I'm not sure I'd call it a "bug" as Chuck's original code does the Right ThingĀ® in 99.9% of the situations you'd use it. If my code does not work in 0.1% of situations, then I'd consider it buggy. But that is just me. :-) But, being

Re: DB2 and WebObjects

2008-04-07 Thread David Avendasora
I'm not sure I'd call it a "bug" as Chuck's original code does the Right ThingĀ® in 99.9% of the situations you'd use it. But, being the PITA that I am, I've come up with a situation where even though the his code can't verify that what I'm doing is safe from a referential- integrity perspect

Re: DB2 and WebObjects

2008-04-06 Thread Chuck Hill
On Apr 6, 2008, at 5:48 PM, Andrew Lindesay wrote: Hello Chuck; I Googled it when you said that as it surprised me. The answer I found was that it did not. Hmmm darn. I was hoping that I had spelt deferred wrong or something. :) I see DB2 has a feature to turn constraints off/on insi

Re: DB2 and WebObjects

2008-04-06 Thread Andrew Lindesay
Hello Chuck; I Googled it when you said that as it surprised me. The answer I found was that it did not. Hmmm darn. I was hoping that I had spelt deferred wrong or something. :) I see DB2 has a feature to turn constraints off/on inside a transaction so I am guessing it would be possib

Re: DB2 and WebObjects

2008-04-06 Thread Chuck Hill
On Apr 6, 2008, at 5:38 PM, Andrew Lindesay wrote: Hello Chuck; Thanks for the overview on that one. No deferred constraints. Sigh. DB2 just dropped a notch in the respect that I had for it. I'm actually not 100% sure on the deferred RI checks for DB2 so leave the respect in place for

Re: DB2 and WebObjects

2008-04-06 Thread Andrew Lindesay
Hello Chuck; Thanks for the overview on that one. No deferred constraints. Sigh. DB2 just dropped a notch in the respect that I had for it. I'm actually not 100% sure on the deferred RI checks for DB2 so leave the respect in place for now! I was wondering if somebody here knows? I see

Re: DB2 and WebObjects

2008-04-06 Thread Chuck Hill
Hi Andrew, On Apr 6, 2008, at 5:09 PM, Andrew Lindesay wrote: Hello; A couple of years ago I was investigating DB2 and WO. A couple of people were kind enough to point me in the right direction. I've got another question. I could be wrong, but suspect that DB2 doesn't support deferred

DB2 and WebObjects

2008-04-06 Thread Andrew Lindesay
Hello; A couple of years ago I was investigating DB2 and WO. A couple of people were kind enough to point me in the right direction. I've got another question. I could be wrong, but suspect that DB2 doesn't support deferred RI checks -- if this is the case, how are people managing to w