IMHO the most important feature about transactions is failure and automatic rollback.
I'm not sure threading and throwing a "fail" flag for the other thread to pick up would be practical. it's not the splitting of the threads, but the join to know what happened "on the other side". In any case the start, commit/rollback for each would need to be on it's own thread (back to the single connection per cftransaction) but it's still an interesting thought... next time I've got some spare minutes to throw some code around... On Mar 20, 4:24 pm, "Zac Spitzer" <[EMAIL PROTECTED]> wrote: > could you use cfthread to create seperate transactions in the same request? > > On Thu, Mar 20, 2008 at 5:20 PM, Owen West > > > > > > <[EMAIL PROTECTED]> wrote: > > > Barry, > > > I wasn't trying to be too harsh - I've been using CF for a number of years, > > and have discovered this about cftransaction before. I just figured (without > > looking) that now that we have access to a J2EE environment maybe Adobe were > > really nice to us CF developers and had this functionality built in. > > > Having built a .NET app previously that did use distributed transactions, I > > know what a total pain it can be - kinda like threading, you can get > > yourself tied up into a really intricate knot! > > > Maybe something for the CF9 wish list... > > > As you said, most database systems allow you to create a linked server and > > just do it that way - doing so allows the data source to promote the > > transaction to a distributed transaction itself, so that will get around the > > whole issue. > > > ;-) > > > Owen West MCP MCAD MCSD > > Computer Programmer > > Applications Development Team > > Information Technology & Telecommunications > > Hunter New England Health > > Ph: (02) 4921 4194 > > Fax: (02) 4921 4191 > > Email: [EMAIL PROTECTED] > > > >>> "barry.b" <[EMAIL PROTECTED]> 20/03/2008 4:47 pm >>> > > > > You can do this using java, so with CF being a J2EE app you should be able > > to use this kind of distributed trx functionality - if you cannot, it would > > be something of a glaring omission by Adobe. > > > not necessarily. > > > you can't do nested transactions in CF but you can in Java (and > > ADO.Net ... FWIW) > > > CFTransaction is connection-based. It just works on one connection to > > the database at a time, holding the connection open to complete the > > transaction. > > > this is why you can't break the transaction up with the start being in > > one cfinclude and the end in another (or different methods for that > > matter). > > > what you CAN do (distributed transactions), is use SQL and "link > > databases" commands (or whatever - I forget) to query one database > > that then reaches into another... that works just fine. > > > don't be too hard on CF in this, OK? I also think that nested > > transactions is a sorry ommision but I've seen the other side of the > > coin from the CF development team and it's a lot of hard work with > > lots of cavaets. I thought that, since CF *is* java and java has > > nested transactions, then it should be easy. I was wrong. > > > It's probably safer to NOT say that "CF *is* Java" but "CF is built on > > top of Java" - there's enough subtle limitations to make the > > distinction and this is one of them. > > > if you really need nested transactions or distributed transactions > > (across multiple data sources) then perhaps shell out to some java > > code that *can* do it? Perhaps a later version will have it? I'm very > > happy to be proven wrong on this. > > -- > Zac Spitzer -http://zacster.blogspot.com(My Blog) > +61 405 847 168- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
