mORMot Open Source

dcoun

Member

From: Crete, Greece

Registered: 2020-02-18

Posts: 392

How to close a database connection?

Somewhere in the forum, I read that if a database connection becomes unusable (eg. out of sync messages, transactions problems, etc) it is better to close it.
Is it possible to that for connections used by TrestServerDB? Is it possible to request to refresh all connections of its connection pool?
The database connection could be through zeos or a TSqlDBPostgresConnection

Thank you in advace

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,207

Website

Re: How to close a database connection?

The framework is able to re-connect after a timeout is expired, or re-create the connection in case of connection-related exception.
This is at mormot.db.sql level, not at REST nor ORM level.

In short, you have nothing to do, the TSqlDBConnectionProperties does it for you with the proper ConnectionTimeOutMinutes and ReconnectAfterConnectionError properties.
See the documentation on those properties.

dcoun

Member

From: Crete, Greece

Registered: 2020-02-18

Posts: 392

Re: How to close a database connection?

Thank you a lot @ab I will try it