[Zope-DB] Connections to DB - Opening & closing

Samir Mishra SamirMishra@cbuae.gov.ae
Wed, 16 Jul 2003 08:50:32 +0400


Hello all,

I have a few python scripts that I'm using to execute SQL scripts. Each time
I submit a set of statements, I have to open a connection & then after I'm
done, close the connection. I feel that I'd get better performance if I were
to use the connection Zope's already established to the DB. Does anyone know
how I can do this?

BTW if anyone's interested in the python external method, let me know. It's
relatively simplistic, without any error trapping, but it works for me.

Regards,
Samir