"Verify Connection" connection string property

"Verify Connection" connection string property

Postby bozr » Tue 06 Mar 2012 09:12

Hi,

I've got a question about the "Verify Connection" connection string property.
When I set this property to true in my connection string always get exceptions saying "Trying to put a closed connection to pool".

When I look into the documentation, I see that it should check the connection when it is obtained from the pool.

The moment when the exceptions are thrown seems quite odd to me, since my application might return closed connections to the pool (hence, faulted connections). However, I assumed that the pool would not complain about this and instead make sure that there are "Min Pool Size" open connections available.

What is the original idea behind the current implementation?
Or did I just run into a bug?

Regards,
Ruud
bozr
 
Posts: 17
Joined: Mon 21 Jun 2010 12:39

Postby bozr » Tue 06 Mar 2012 09:13

Forgot to say that I'm using version 5.70.311.
bozr
 
Posts: 17
Joined: Mon 21 Jun 2010 12:39

Postby Pinturiccio » Wed 07 Mar 2012 13:31

bozr wrote:I've got a question about the "Verify Connection" connection string property.

Did you mean ValidateConnection property?

We could not reproduce the issue with 'ValidateConnection=true'. If it is possible, create and send us a small test project with DDL/DML scripts for reproducing the issue.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL