Re: [cx-oracle-users] Fw: cx_oracle question - cx_Oracle.DatabaseError

[<dan...@co...>]

On Friday, January 12, 2007 6:39 AM, Gregg Ziliani wrote:

> Now I do not have problems with connecting to the database in any of
> the other python scripts for this website. Is it an issue of opening
> too many connections to Oracle within the same script?=20

Since I do not know your data, I can not see how often cx_Oracle.connect
gets called. But looking at your cron.py code, this could be a problem.

Open the connection ONCE at the start of the script (before _auto()) and
then use this global connection variable every where in this script.
Another good idea is to explicitly close all your cursors to avoid the
'too many open cursors' problem.

Lets see whether this works better.

Daniel