Need Help with Locking

[CFRAM]

I need help with understanding about locking. I have my DSN created as
Application Variable . I want to lock a transaction in one of the module to is
used for update. I don't want users to get affected when browsing the data
using the other modules.

Thanks

[jdeline]

Here are some references you may find useful.
[url]http://richmond-cfug.btgi.net/CFLOCK.PDF[/url]
[url]http://www.webtricks.com/sourcecode/code.cfm?CodeID=25[/url]

[url]http://livedocs.macromedia.com/coldfusion/5.0/Developing_ColdFusion_Applications[/url]
/appFramework.htm

[CFRAM]

Still I not clear by reading the articles. Does CFLOCK OR CFTRANSACTION work the same way as database row lock in Oracle.

[CFRAM]

Still I am not clear by reading the articles. Does CFLOCK OR CFTRANSACTION work the same way as database row lock in Oracle.

[MattRobertson]

They work nothing like a row lock. CFLOCK allows thread-safe access to
shared-memory variables, or (using a named lock) exclusive access to a code
block for one user... the latter of which you had better be REAL sure about
before utilizing.

CFTRANSACTION provides rollback capability in case a database operation (or
one of multiple operations encapsulated by a single cftransaction block) fails.

If i understand your post correctly, you want to ensure a single user has
access to a particular code block? If so, CFLOCK it with a named lock. i.e.

<cflock name="STRANGLER" timeout="3">
<cf_getThisOverWithQuick>
</cflock>

In the above, when one user invokes the lock named STRANGLER no one else can
invoke it (or run the code within) until that code is done and the lock is thus
released.

Generally this is something you never want to do in a web application.
'never' is perhaps too strong but not by much. Depending on your context
cf_LockMonger might be what you are after instead:

[url]http://mysecretbase.com/lockmonger.cfm[/url]

It will keep you from choking your web application to death ;-)

HtH,

--Matt--
MSB Web Systems... [url]http://mysecretbase.com[/url]
The trouble with most jobs is the job holder's resemblence to
being one of a sled dog team. No one gets a change of scenery
except the lead dog.
- Moer's truism

[BKBK]

>... I need help with understanding about locking.

>... I have my DSN created as Application Variable

If the code <cfset Application.myDSN = "RealDatabaseDSNname"> appears
just once in your application, usually in Application.cfm or Application.cfc,
then
it is safe to use Application.myDSN everywhere, without the need for a lock.

[CFRAM]

Thanks Guys. That was really helpfull.