[Zope] Close Database Connection /Newbie Question

[Dennis Allison]

I suspect the problem has to do with open transactions.  You might check
the PySQL documentation and the MySQLdocs for details.  Recent versions 
of MySQL and the Zope DB adaptor automatically opens a new transaction.

If you are not using transactions, append a'-' to your connection string
to disable automatic transaction processing.

-dra



On Thursday, 9 May 2002, Dieter Maurer wrote:

> Philipp Giere writes:
>  > ...
>  > db = self.ZMySQL_Connection()
>  > With db.query("SQL") i send requests to the database.
>  > 
>  > It works fine.
>  > But after a while I get an error "too many connections". Seems logical
>  > for me, because I don't close the connection. But how do I close it?
>  > Something like db.close() doesn't work. 
> Why not? What happens?
> 
> It should work...
> 
> Dieter