Pooling question

Pooling question

Postby perqdb » Thu 12 Jan 2017 23:01

In the documentation for PgSqlConnection.ClearPool static method (https://www.devart.com/dotconnect/postgresql/docs/Devart.Data.PostgreSql~Devart.Data.PostgreSql.PgSqlConnection~ClearPool.html) it says "Pool is automatically cleared if a connection is idle for some time or closed by the server." Is there anyway to set the "idle" time to automatically clear the connections? I know there is a ConnectionLifetime setting, but that sounds like it will only close the connection if it is re-used past that timeout.

My goal is to have pooled connections closed automatically if they have been idle for a pre-set amount of time, (2 minutes, for example). I have not been able to find a way to do this with the DevArt pooling settings. Am I missing something? (Or misunderstanding how something works?)
Posts: 1
Joined: Thu 12 Jan 2017 13:35

Re: Pooling question

Postby Pinturiccio » Fri 13 Jan 2017 16:10

dotConnect for PostgreSQL does not support such feature. There is no such possibility to automatically close connections which are idle for some specific time.
Devart Team
Posts: 2062
Joined: Wed 02 Nov 2011 09:44

Return to dotConnect for PostgreSQL