Thanks. This may be what he needs. On a follow-up, and no disrespect to you or the docs, but have you used Oracle with CF and found this to be true (I'm assuming so based on your Oracle DBA status)? I'm asking as this information will be used to make a decision between CF and Asp.
> That is not correct. > > From the CF Administrator help text: > > Connection Timeout > Enter the maximum number of minutes after the database connection is made > that you want ColdFusion to cache a connection after it is used. > > This option is different from the server setting "Limit database connection > inactive time," which is server-wide and releases only cached connections > that have been inactive for the specified period. > > This "Connection Timeout" setting does not return a connection to the cache > after a specified time no matter how often it is used. > "" or 0 to indicate that the connection timeout is never enforced > > Limit cached database connection inactive time. > Limits the maximum amount of time that a cached database connection is > inactive before it is disconnected. Enter '0' if you want inactive > connections to be maintained as long as the ColdFusion server is executing. > A database connection is cached when the maintain database connections > attribute is checked for a data source. > > Hope this helps, > Steve > > ------------------------------------- > Steven Monaghan > Oracle DBA / Cold Fusion Developer > MSC Industrial Direct Co., Inc. > http://www.mscdirect.com > ------------------------------------- > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 14, 2003 1:19 PM > To: SQL > Subject: Oracle question > > > This question was just asked of me and I don't know enough about Oracle to > get > an answer. Any Oracle users with experience out there in this area? > "Cold Fusion 5.0 has no mechanism for releasing a connection after an Oracle > database call." > > Thanks > > > Michael Dinowitz > Master of the House of Fusion > http://www.houseoffusion.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
