Re: [SQLObject] Leaking connections

[Michael W. <mw...@mi...>]

Is there any reason why you are opening so many connections? 

In a typical long-running web app I have 2 - 4 connections open max
(depending on how many processes SCGI - I use Quixote - has forked),
even when the app runs for many days without restarting.

I've not looked closely at the __connection__ magic variable to know how
that behaves.

For my purposes I created a singleton class pattern which has a
get_connection() method and assigns the result of this to each
SQLObject's _connection property.

On Mon, 2004-07-19 at 04:11, Florian Schulze wrote:
> Hi!
> 
> Is anyone using SQLObject with long running processes which open many  
> (short lived) connections? Currently there seems to be no way to really  
> close connections. Sooner or later I get errors about to many connections  
> to the database and many many idle database processes.
> 
> I'm using SQLObject from Subversion (Rev 163) with Postgresql (psycopg).
> 
> Regards,
> Florian Schulze
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

--
Mike Watkins
mw...@mi...


Here in my heart, I am Helen;
	I'm Aspasia and Hero, at least.
I'm Judith, and Jael, and Madame de Sta"el;
	I'm Salome, moon of the East.

Here in my soul I am Sappho;
	Lady Hamilton am I, as well.
In me R'ecamier vies with Kitty O'Shea,
	With Dido, and Eve, and poor nell.

I'm all of the glamorous ladies
	At whose beckoning history shook.
But you are a man, and see only my pan,
	So I stay at home with a book.
		-- Dorothy Parker