Maureen, I had something similar happen on a machine running SUSE 9/CF7 connecting to a PostgreSQL database with a third-party driver.
My understanding, as I've read it, is that connections are only pooled across the length of the request so if your code throws a database error somewhere in the request, there's a possibilty that the connection will "stick" open. In our case it was a non-superuser limit on concurrent connections we were hitting with PostgreSQL so the problem was snowballing since the database errors were causing stuck connections and the number of connections was increasing - causing more database errors. We upped the max-allowed connections in our pg config files and, as Dave suggested, we added a max allowed connections to the datasource and that seems to have solved the problem by forcing CF to re-use the connection. We're looking at upgrading that server to CF8 in the not-too-distant future and I'm looking forward to seeing if that solves the problem between the CF and JVM upgrades involved. Also, if the above and Dave's suggestions don't solve the problem, you might try see if there is a way to use the Oracle oracle.jdbc.pool.OracleConnectionPoolDataSource class ()directly (http://download.oracle.com/docs/cd/B10500_01/java.920/a96654/connpoca.htm ) to clean up the pool periodically. HTH, Jon On Apr 21, 2008, at 1:43 PM, Maureen Barger 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? > 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? > > 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. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
