mysql / zope db connection issue

"Jamie O'Keefe" <[email protected]>
Newsgroups gmane.comp.web.zope.database
Message-ID <[email protected]>
Hi,

I have written a series of zope pages for a person to update their
record in our mysql database.   They use a zpt->python->db sql->db
driver->db flow and work pretty well.

Unfortunately, if enough people use it, the number of open db
connections grows until it hits a limit and the db stops accepting
connections.  I have seen that there is a connection issue with zope
and mysql, but have not been able to find a solution.  Is there one?

Also, I put in some exception handling to trap any db errors and email
the post if there are any.  However, i am not sure it is working.  I
performed a test to the db update from my page with the db off and got
a Database Error that wasn't caught by my exception handler.  I am not
sure why since I thought Exception would be the root of Database
Errors.  My code looks like this:

try:
  result = context.updatePerson(**query_args)
  return text
except Exception:
  try:
    mto = "<to address>"
    mfrom = "<from address>"
    subject = "Updated supporter information"
    body = printed
    context.MailHost.simple_send(mto, mfrom, subject, body)
    print result
    return text
  except Exception:
    errorText = '<h1>Ooooppps!</h1><p>There was an error submitting
your information to our database and our backup logging method. 
Please email the <a href="mailto:webmaster@<domain>">webmaster</a>
that you got an error so that we can track it down and fix
it.</p><p>Thanks!</p>'
    print errorText
    return printed
    return errorText

The traceback error is:

Exception Type  	Database Error
Exception Value 	updatePerson is not connected to a database

Any insights would be most welcome.

Thanks!

Jamie
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.