Re: DB2 and WebObjects
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 perspective, I know it will be safe due to my specific business-logic rules. So, if by saying he gave me a patch for the bug, he means he told me which safety to disable, I guess that would be about right. :-) Dave On Apr 6, 2008, at 8:26 PM, Chuck Hill wrote: David Avendasora pointed out a bug in it if you are using self- referential relationships (entity with a relationship to itself). I gave him a patch, but I really need to rethink some parts of that code. It works for most things, but I think there are some more buggy cases. It also does not (yet) order operations on the same table which self-referential relationships really need. ___ 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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: DB2 and WebObjects
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 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 perspective, I know it will be safe due to my specific business-logic rules. So, if by saying he gave me a patch for the bug, he means he told me which safety to disable, I guess that would be about right. :-) IIRC, there was also a change from entity().name() to entity.externalName(). Chuck On Apr 6, 2008, at 8:26 PM, Chuck Hill wrote: David Avendasora pointed out a bug in it if you are using self- referential relationships (entity with a relationship to itself). I gave him a patch, but I really need to rethink some parts of that code. It works for most things, but I think there are some more buggy cases. It also does not (yet) order operations on the same table which self-referential relationships really need. -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
DB2 and WebObjects
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 work around this problem with EOF? Chuck; does your operations ordering system work for more than just MSSQL? cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ 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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: DB2 and WebObjects
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 RI checks -- if this is the case, how are people managing to work around this problem with EOF? Chuck; does your operations ordering system work for more than just MSSQL? It works for anything. It is high enough up in EOF to be DB agnostic. It is just _needed_ for MSSQL. I leave it on when using FrontBase (which is most of the time). David Avendasora pointed out a bug in it if you are using self- referential relationships (entity with a relationship to itself). I gave him a patch, but I really need to rethink some parts of that code. It works for most things, but I think there are some more buggy cases. It also does not (yet) order operations on the same table which self-referential relationships really need. No deferred constraints. Sigh. DB2 just dropped a notch in the respect that I had for it. Chuck -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: DB2 and WebObjects
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 DB2 has a feature to turn constraints off/on inside a transaction so I am guessing it would be possible to create a JDBCAdaptor subclass that automatically did that sort of thing when it goes to perform adaptor operations on a channel. cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ 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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: DB2 and WebObjects
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 now! I was wondering if somebody here knows? I Googled it when you said that as it surprised me. The answer I found was that it did not. I see DB2 has a feature to turn constraints off/on inside a transaction so I am guessing it would be possible to create a JDBCAdaptor subclass that automatically did that sort of thing when it goes to perform adaptor operations on a channel. Yes, that would be possible. But does that mean you can commit data that violates the constaints? Chuck -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: DB2 and WebObjects
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 possible to create a JDBCAdaptor subclass that automatically did that sort of thing when it goes to perform adaptor operations on a channel. ... Yes, that would be possible. But does that mean you can commit data that violates the constaints? I _think_ I am reading that it can play catch-up from when you turn it back on again. cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ 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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: DB2 and WebObjects
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 inside a transaction so I am guessing it would be possible to create a JDBCAdaptor subclass that automatically did that sort of thing when it goes to perform adaptor operations on a channel. ... Yes, that would be possible. But does that mean you can commit data that violates the constaints? I _think_ I am reading that it can play catch-up from when you turn it back on again. That could OK then. You would have (want) to create an exception with enough info to identify the constraint downstream. Chuck -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]