MySqlHelper CommandTimeout
Posted by:
Mike Vyce
Date: February 14, 2014 09:45AM
I'm using methods belonging to MySqlHelper for all of my database access in a web project, and I have a particularly long running SELECT query which times out every time.
Having scoured the internets, I have become convinced that increasing the CommandTimeout property (default 30secs?) of an underlying MySqlCommand would allow the query to complete its execution. However I can't find a way to set this on the MySqlHelper object directly.
I would like to be able to set it on the MySqlHelper directly, as that saves me from creating my own MySqlCommand, which I have so far been able to avoid. Is there a way to do that which I have missed?
Alternatively, is there a way of setting the CommandTimeout for the whole of my web project, or even on the mysql database?
Mike
Subject
Written By
Posted
MySqlHelper CommandTimeout
February 14, 2014 09:45AM
February 24, 2014 11:27AM
February 25, 2014 08:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.