[Lazarus] MariaDB gone away after long inactivities

[Aradeonas]

I don't know much about disconnecting problem but I know you dont need
to set transaction every time ,just this line work for others
automatically :
SQLConnection1.Transaction:=SQLTransaction1;

About disconnecting you can make procedure that reconnect to DB when it
disconnected or put a timer and check connection some times and if it
was disconnected or other problem try to reconnect and put a counter so
if MariaDB gone away for always,turn your auto connect system to off.

Regards,
Ara


-- 
http://www.fastmail.com - Access all of your messages and folders
                          wherever you are