Well its not really the same. CFtransaction will prevent race conditions and rollbacks in CF, while CF has a lock and wont send similar requests until the transaction is complete. Another request could come in through cf that is not in a transaction that is executed.
Transactions on the database side will actually lock rows and the specific data being updated. CF doesnt have that level of power, all its basically doing is pausing all other requests, not locking rows. They are almost two completely different functions. -Adam On 6/7/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > Because this is a big oilfield company that spent way too much money with > Oracle and is looking for any excuse to just use it. They appear to not care > if it is used "right" or not. The web applications do not do much more than > simple queries, other groups might very well be doing things much more > complex in Oracle. We also do not have access to any of the administrative > side of things, typically a web application has a user in Oracle that would > appear to have full access to that tablespace, although I do know when I was > tried to create a "type" it did not have permissions but their fix was > simply to grant that permission to all users. That same user is what is used > by the CF server connection. > I do believe I was saying simple inserts and updates, I just have to wonder > what in the world people are collecting through a web interface that > requires complex inserts and updates. Now some of the select queries, such > as for some of the reports I would not label simple, not sure if I would use > complex either but that is why I tried not to specify select queries. > I was just trying to verify on cftransaction, the first email implied to me > that the only way it could be done was through a stored procedure. > On 6/7/05, Adrocknaphobia <[EMAIL PROTECTED]> wrote: > > > > Hrmm, if you arent taking advantage of Oracle security and you are > > just running simple queries... then why invest in such an expensive > > database? > > > > As far as cftransaction, it does work that way, but that logic really > > belongs in the model (the database) not the controller (cf). > > > > -Adam > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208820 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
