zeoslib: check if mysql connection is alive
lazarus / 16-Databases

----------------------------------------------------------------------
giulianoz · 2009-12-19 14:25

Hello,
 Is it possible to check if a previously connected TZConnection (mysql
protocol if that matters) is still active ? I've tried to check the
connected propertiy but it doesn't change when I stop the mysql
server. Also the AfterDisconnect event isn't fired when the server
goes down.

OS and server are on fedora 12 64bit pc, fpc/lazarus/zeoslib compiled
from svn/source today

thanks

giuliano

----------------------------------------------------------------------
zeljko · 2009-12-19 15:02

Connected & AfterDisconnect doesn't work in such way.
Zeos don't know if server went down. You have to ping it, so if ping
is false, then execute connection.Disconnect.

----------------------------------------------------------------------
giulianoz · 2009-12-19 15:16

Thanks for the info, I'll do some ping checks