> I am trying to figure out the technical ramifications of > defining the username and password for a specific DSN in a > separate text file and how it may relate to connection > pooling v. supplying the user/pass directly in the DSN. Once > the file is loaded, user and password are passed to cfqueries > using application variables. > > If the user/pass is defined externally, can connections in > the same pool be re-used?
Yes. > If the user/pass is added to the DSN, the user/pass removed > from the external text file and the cfquery strings still > contain the Application variables for them, what happens to > the connection pool? I'm pretty sure that if you define username and password parameters for CFQUERY, and don't provide useful values, the query will fail. If that doesn't happen, then you can safely assume that CF is using the DSN values for authentication, and those will be in a single connection pool. > The reason I am trying to wrap my head around this is that > our datasource (Oracle) has an increasing number of connections > that are never released. Over time, the application becomes > sluggish. It also uses stored procs. If you're using a single username and password for all your CFQUERY tags, it doesn't matter whether this originally came from a text file or from the datasource. They'll all share the same connection pool. It's certainly possible that connections are never being closed. You might check for a newer version of database drivers - if you're using CF Enterprise, you'd get those from http://www.adobe.com/support/coldfusion/, otherwise, you'd get them from your database vendor. You might also set a connection limit, which might help force CF to reuse connections rather than creating new ones. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4