It seems like one of the benefits to using cfquery as opposed to JDBC directly is that you don't have to deal with connection issues and what have you. It seems to me that if you need that much control over the connections than you should be using JDBC directly.
-Matt On Monday, July 21, 2003, at 04:44 PM, Barney Boisvert wrote: > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
