can i set up a mysql db connection as a class ?
nephish at xit.net
nephish at xit.net
Thu Apr 27 20:15:59 EDT 2006
hey there,
i have a huge app that connects to MySQL. There are three threads that
are continually connecting and disconnecting to the db. The problem is,
if there is an error, it faults out sometimes without closing the
connection. i connect like this.
db = MySQLdb.connect(host="localhost", user="MyUser",
passwd="MyPassword", db="Stuff")
cursor=db.cursor()
then i use the cursor.execute("SELECT yadda yadda
my question is, is there a way i can set up a global connection so that
when the program loads, it connects once, then stays connected ? maybe
i could assign instances of the cursor ?
please someone let me know if you have any good ideas
sk
More information about the Python-list
mailing list