Request TimeOut Value Property for ZConnection

Freature requests from users for ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist, mdaems

Post Reply
ChaosBiker
Fresh Boarder
Fresh Boarder
Posts: 22
Joined: 26.08.2008, 12:36

Request TimeOut Value Property for ZConnection

Post by ChaosBiker »

Request TimeOut Value Property for ZConnection
mparak
Senior Boarder
Senior Boarder
Posts: 81
Joined: 12.09.2005, 06:51
Location: Durban South Africa
Contact:

Post by mparak »

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
Post Reply