Re: refresh connection using MySQLdb

[Fred Mark]

I have the same problem. I have a client application that uses a mysql database. When the application starts it opens the connection once and closes it when the application quits. When I insert stuff into the database from my application I see it updated but when another program inserts things into the database I need to reopen the application (the connection) to see the new items in the database.

So is this normal behavior? Before fetching information from a database we have to open a connection each time?

Update :
I've just figured out what the problem was. If I commit the connection (conn.commit()) and redo the query with my cursor object (without creating a new one) it gets the new rows from the database.



Edited 1 time(s). Last edit at 02/07/2007 08:49AM by Fred Mark.