thanks, we are using Oracle driver provided in the macromedia.jar, 3.5 since Oracle's own driver does not support stored procedures.
On Mon, Apr 21, 2008 at 1:56 PM, Dave Watts <[EMAIL PROTECTED]> wrote: > > 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:303902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
