On Sun, 28 Dec 2014, ERICK VAN ZYL wrote:
Good day all,
I'm new like Databases in Lazarus,
I have noticed a connection problem while using my Lazarus application with
database like MySQL/MariaDB; after a long inactivity with my Lazarus
Application using MySQL, the application lost a connection with the database
until
I have to restart the apps. Even after opened and closed the connection, It
that’s not work until I have to restart the apps.
If I used another database like SQLite, the problem didn't occur (I don't have
to restart the Apps for further DB request).
Can any one assist me regarding this issue?
There is no proper solution for this.
This is the mysql client engine that throws this error.
We have created a helper workaround for this in TSQLConnection:
procedure Close(ForceClose: Boolean=False);
Using this, you can forcedly close the connection.
this allows you to catch the mysql error, close and re-open the connection.
Michael.
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
