Request TimeOut Value Property for ZConnection
Posted: 26.08.2008, 12:54
Request TimeOut Value Property for ZConnection
I suspect that you mean to ask for a way to have the application gracefully timeout when a request takes longer than nn seconds.
I have been searching for an answer to this for a while, and found that you could type timeout=5 in the property section of the TZconnection as I was advised to do, but it seems to have no effect whatsoever.
I use the icmp method of pinging the server to establish that the server is responding at a network level and then ASSUME the Mysql service will process my query. This is less than ideal, but for the better part gets the job done.
If some kind soul has the answer that we seek, it would be great.
Some method of establishing if the MySQL service is up and running (mysqlping is not the answer) . And a method of timing out with error codes if the SQL encounters a server that takes too long to respond
Regards
Mparak
Durban South Africa
www.cad.co.za