Subject RE: [IBO] Large number of DB connections left open in a service
Author Jason Wharton
If you are using DisconnectToPool then it's possible handles could be going in to the pool but something could be preventing them from being utilized from the pool.

There should be no problem using this in a service application.  In fact, it is a place where I believe it should be ideal.
 
Jason Wharton
 


From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Thursday, March 22, 2018 2:59 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Large number of DB connections left open in a service

I have a service that is leaving a lot of database connections open. I checked and everywhere I create the data module that has the TIB_Conneciton I free.


I do call .DisconnectToPool. Might that have something to do with it? Should this be safe in a service?

The TIB_Connection object is created with the data module, and in the .Destroy of the DM I call DisconnectToPool before it is freed.

I am in the testing phase of this, but I really don't know where to look outside of that.

Ed Dressel