have to invalidate connection after each query

Posted:
Fri Feb 03, 2012 8:15 pm
by mfrederickson
I'm running against mysql. Every time I run a new query I have to invalidate/reconnect to the database or I get an error-- even if I just try to rerun the same query twice in a row. Why is that? It is very frustrating/non-productive. Anyway to fix it?
Re: have to invalidate connection after each query

Posted:
Sat Feb 04, 2012 11:36 am
by Serge
Hi,
Obviously it is not normal. Generally you may execute as many queries you want and it doesn't cause any problems with connection.
Could you say what version of MySQL do you use and what exact error occurs after query execution?
Thanks!