[Lazarus] MariaDB gone away after long inactivities

Eric Kom erickom at metropolitancollege.co.za
Tue Aug 18 11:54:29 CEST 2015



On 2015/08/18 08:06 AM, Aradeonas wrote:
> 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;
So if I understand, for good practice I must not have many 
TSQLTransaction? Even if I got many TSQLQuery
> 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
>
>





More information about the Lazarus mailing list