Maximum pool size reached? What does that mean?

Data Abstract
1

I have no idea how, with only casual developer use of a RemObjects DataAbstract custom server in Delphi, I could be reaching a “Maximum pool size reached” exception with only ONE client connected at a time, and a total of less than 100 connections and SDK method invocations. How is it possible to leak that badly and how do I figure out how come this is happening?

Is this some kind of “Pool cleanup by garbage collection triggered by an exception” (thus it trips my debugger) or is this a bad thing? What is it and what do I do about it?

2

I have a suspicion that I’ve been using this code snippet liberally in My Remobjects SDK methods, and somehow I’m leaking connections:

connection := Schema.ConnectionManager.NewConnection(Schema.ConnectionManager.GetDefaultConnectionName);

… Then create datasets to do temporary queries. Somewhere one of those must be sticking around too long…

3

Hello,

Of course it could be so. So I can suggest one way to control count of created connection. You can use BeforeAcquireConnection event to control count of created connections and BeforeReleaseConnection event to control count of released connections. So you can see is your application work correctly with connections.

Best regards