[Firebird-net-provider] [FB-Tracker] Created: (DNET-552) ConnectionLifetime with value 0 (zero) is no longer treated as infinite but really as zero.

[Erik J. M. (JIRA) <tr...@fi...>]

ConnectionLifetime with value 0 (zero) is no longer treated as infinite but really as zero.
-------------------------------------------------------------------------------------------

                 Key: DNET-552
                 URL: http://tracker.firebirdsql.org/browse/DNET-552
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.1.5.0
            Reporter: Erik Jan Meijer
            Assignee: Jiri Cincura


In NETProvider\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbConnectionPoolManager.cs , Pool.CleanupPool() does the following:

 var keep = available.Where(x => x.Created.AddSeconds(_connectionString.ConnectionLifeTime) > now).ToArray();

This does not take into account the default(!) value of zero for _connectionString.ConnectionLifeTime.

The effect is that connections are closed and recreated for every request.
You can see TCP-connections closing and new ones reopening by using TcpView by SysInternals.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira