I have set Pooling = True and ConnectionLifeTime = 10 in my connection
string.
The expected result would be that 10 seconds after the connection is last
used the connection is closed.
Unfortunately looking at the connections using Database Workbench the
connection seems to stay open till program termination.
Having looked at the source code I see a timer and it's associated callback
that implements this functionality in FbConnectionPool.cs.
Setting a breakpoint in the callback CleanupWorker it's only called once and
then never again.
The line:
pool.cleanupTimer.Dispose();
seems to be the culprit since commenting it out gives the expected behavior
of the the cleanup being performed and the callback being called multiple
times.
Is this a bug or is it by design?
Thank You
--
Gerdus van Zyl
http://about.me/gerdus
------------------------------------------------------------------------------
Storage Efficiency Calculator
This modeling tool is based on patent-pending intellectual property that
has been used successfully in hundreds of IBM storage optimization engage-
ments, worldwide. Store less, Store more with what you own, Move data to
the right place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
