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

[Gregg Z. <gre...@ya...>]

Daniel,=0A=0AThanks for the assist. I rewrote the code and moved the connec=
tions to the top. I closed the cursors as necessary and the script runs wit=
hout a hitch. It was definitely those connections stepping on one another.=
=0A=0ABest regards,=0A=0AGregg=0A=0A----- Original Message ----=0AFrom: "da=
nie...@co..." <dan...@co...>=0ATo: cx-oracle-users@=
lists.sourceforge.net=0ASent: Friday, January 12, 2007 3:25:49 AM=0ASubject=
: Re: [cx-oracle-users] Fw: cx_oracle question - cx_Oracle.DatabaseError=0A=
=0AOn Friday, January 12, 2007 6:39 AM, Gregg Ziliani wrote:=0A=0A> Now I d=
o not have problems with connecting to the database in any of=0A> the other=
 python scripts for this website. Is it an issue of opening=0A> too many co=
nnections to Oracle within the same script? =0A=0ASince I do not know your =
data, I can not see how often cx_Oracle.connect=0Agets called. But looking =
at your cron.py code, this could be a problem.=0A=0AOpen the connection ONC=
E at the start of the script (before _auto()) and=0Athen use this global co=
nnection variable every where in this script.=0AAnother good idea is to exp=
licitly close all your cursors to avoid the=0A'too many open cursors' probl=
em.=0A=0ALets see whether this works better.=0A=0ADaniel=0A=0A-------------=
------------------------------------------------------------=0ATake Surveys=
. Earn Cash. Influence the Future of IT=0AJoin SourceForge.net's Techsay pa=
nel and you'll get the chance to share your=0Aopinions on IT & business top=
ics through brief surveys - and earn cash=0Ahttp://www.techsay.com/default.=
php?page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV=0A________________________=
_______________________=0Acx-oracle-users mailing list=0Acx-oracle-users@li=
sts.sourceforge.net=0Ahttps://lists.sourceforge.net/lists/listinfo/cx-oracl=
e-users=0A=0A=0A=0A=0A=0A=0A=0A =0A________________________________________=
____________________________________________=0ATV dinner still cooling? =0A=
Check out "Tonight's Picks" on Yahoo! TV.=0Ahttp://tv.yahoo.com/