Next question: Will any other concurrently processing requests use that connection, or is it reserved for the exclusive use of the current thread? It seems to me that when a request gets a connection, it is removed from the pool of connections until the request is over, but like Jochem, I'm quite interested in a formal specification of the behaviour, one way or the other.
--- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Sean A Corfield [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 1:23 PM > To: CF-Talk > Subject: Re: read-only SQL transactions > > > On Monday, Jul 21, 2003, at 08:03 US/Pacific, Dave Watts wrote: > >> And I believe it is currently not guaranteed that multiple > >> queries from one request will use the same connection. Right? > > That's an interesting question. It's my understanding that multiple > > queries > > using the same datasource within a single request do use the same > > connection, based on conversations I've had with some MM people, but I > > can't > > say that it's definitively true. > > I asked the CF product team and they said: > > "All .cfm page requests that use the same Datasource will get the same > connection back. The Connection object is stored in the Threadlocal > object and reused for subsequent connection requests on the page." > > So it sounds like Dave's understanding is correct. > > Sean A Corfield -- http://www.corfield.org/blog/ > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwood --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.501 / Virus Database: 299 - Release Date: 7/14/2003 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4