334
Chapter 15: Using Persistent Data and Locking
Sample locking scenarios
The following examples present scenarios in which you need to lock ColdFusion code. These
scenarios show only two of the circumstances where locking is vital.
Reading and writing a shared variable
If you have an application-wide value, such as a counter of the total number of tickets sold, you
might have code such as the following on a login page:
<cfset Application.totalTicketsSold = Application.totalTicke
ticketOrder>
When ColdFusion executes this code, it performs the following operations:
1
Retrieves the current value of Application.totalTicketsSold from temporary storage.
2
Increments this value.
3
Stores the result back in the Application scope.
Suppose that ColdFusion processes two ticket orders at approximately the same time, and that the
value of Application.totalTicketsSold is initially 160. The following sequence might happen:
1
Order 1 reads the total tickets sold as 160.
2
Order 2 reads the total tickets sold as 160.
3
Order 1 adds an order of 5 tickets to 160 to get 165.
4
Order 2 adds an order of 3 tickets to 160 to get 163.
5
Order 1 saves the value 165 to Application.totalTicketsSold
6
Order 2 saves the value 163 to Application.totalTicketsSold
The application now has an inaccurate count of the tickets sold, and is in danger of selling more
tickets than the auditorium can hold.
To prevent this from happening, lock the code that increments the counter, as follows:
<cflock scope="Application" timeout="10" type="Exclusive">
<cfset Application.totalTicketsSold = Application.totalTicke
ticketOrder>
</cflock>
The
cflock
tag ensures that while ColdFusion performs the processing in the tag body, no other
threads can access the Application scope. As a result, the second transaction is not processed until
the first one completes. The processing sequence looks something like the following:
1
Order 1 reaches the lock tag, which gets an Application scope lock.
2
Order 1 reads the total tickets sold as 160.
3
Order 2 reaches the lock tag. Because there is an active Application scope lock, ColdFusion
waits for the lock to free.
4
Order 1 adds an order of 5 tickets to 160 to get 165.
5
Order 1 saves the value 165 to Application.totalTicketsSold.
6
Order 1 exits the lock tag. The Application scope lock is now free.
7
Order 2 gets the Application scope lock and can begin processing.
8
Order 2 reads the total tickets sold as 165.
9
Order 2 adds an order of 3 tickets to 165 to get 168.
10
Order 2 saves the value 168 to Application.totalTicketsSold.
Summary of Contents for ColdFusion MX
Page 1: ...Developing ColdFusion MX Applications...
Page 22: ...22 Contents...
Page 38: ......
Page 52: ...52 Chapter 2 Elements of CFML...
Page 162: ......
Page 218: ...218 Chapter 10 Writing and Calling User Defined Functions...
Page 250: ...250 Chapter 11 Building and Using ColdFusion Components...
Page 264: ...264 Chapter 12 Building Custom CFXAPI Tags...
Page 266: ......
Page 314: ...314 Chapter 14 Handling Errors...
Page 344: ...344 Chapter 15 Using Persistent Data and Locking...
Page 349: ...About user security 349...
Page 357: ...Security scenarios 357...
Page 370: ...370 Chapter 16 Securing Applications...
Page 388: ...388 Chapter 17 Developing Globalized Applications...
Page 408: ...408 Chapter 18 Debugging and Troubleshooting Applications...
Page 410: ......
Page 426: ...426 Chapter 19 Introduction to Databases and SQL...
Page 476: ...476 Chapter 22 Using Query of Queries...
Page 534: ...534 Chapter 24 Building a Search Interface...
Page 556: ...556 Chapter 25 Using Verity Search Expressions...
Page 558: ......
Page 582: ...582 Chapter 26 Retrieving and Formatting Data...
Page 668: ......
Page 734: ...734 Chapter 32 Using Web Services...
Page 760: ...760 Chapter 33 Integrating J2EE and Java Elements in CFML Applications...
Page 786: ...786 Chapter 34 Integrating COM and CORBA Objects in CFML Applications...
Page 788: ......