Hi,

I have a Python class that my Zope application uses to talk to a relational database (MySQL for now). I am using a Z SQL Connection (ZMySQLDA) object to handle DB connectivity. When I initialize, I get a handle of the connection object like this:


import Zope
setattr(self, CONNECTION_NAME, getattr(Zope.app(),CONNECTION_NAME))

Where CONNECTION_NAME is a string that matches the ID of the connection object that I have in the Root folder of Zope.

Then I run queries like this:

from Products.ZSQLMethods.SQL import SQL

setattr(self, '_selectProperties',
            SQL('_selectProperties', '', CONNECTION_NAME, 'schemaId',
'SELECT * FROM ' + TABLE_NAME[self._context.id] + ' WHERE SCHEMA_ID = <dtml-sqlvar schemaId type="int">'))

The life of this class should be Zope transaction (I am hooking into Shared.DC.ZRDB.TM.TM to manage these objects).

The problem I am running into is I seem to be running out of connections. Everytime I inititialize and run "show processlist;" within MySQL, the number of connections increases. I get to a maximum of 3 and then my Zope instance hangs.

Is there any reason why these DB connections do not get reused or destroyed after queries are made?

Any ideas?

Thanks,

Seth

--
Seth Gottlieb
Optaros, Inc.
60 Canal Street
Boston, MA 02114
e: [EMAIL PROTECTED]
v: 617.227.1855 ext. 107
f: 617.227.1755
m: 617.852.2956
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Reply via email to