Re: refresh connection using MySQLdb

[Andy Dustman]

Two problems here:

1) You don't need to do

while curs.nextset() != None

. Just do

while curs.nextset()

. Additionally, calling a stored procedure returns n+1 result sets: The stored procedure itself returns n, while calling it returns one more. Looping like that is probably not a good idea, unless the procedure is returning a variable number of result sets.

2) As has been pointed out, you are in a transactional environment (REPEATABLE READ). To "refresh", do a

curs.rollback()

or

curs.commit()

if you made changes to be saved.