What is the proper way for pooling of TCustomConnection instances in Delphi, that allows to distinguish between instances that have effectively equal connection properties and the ones that are effectively unequal?
I’ve tried searching the RTL and VCL sources and didn’t find a generic way.
I could copy either of the specific ones I found (see list below) and adapt them to a more generic solution or adapt one of the answers in #16404051 to be for TCustomConnection, but I wonder if there is an existing solution for TCustomConnection in the first place.
Specific ones I found in Delphi XE8:
- DBX: unit Data.DBXPool
- FireDAC: unit FireDAC.Stan.Pool
- IBX: unit IBX.IBConnectionBroker
Source [WayBack] database connection – Looking for a generic way to pool TCusomConnection in Delphi – Stack Overflow
Hopefully by now I’ve some implementation for this that works nicely.
If not, these might get me started too:
- [WayBack] Boosting Work Classes with a mini Object Pool – DelphiTools
- [WayBack] The Delphi Geek: Building a connection pool
- [WayBack] DBXPooling and Broken Connections « Daniel Magin’s Weblog
- [WayBack] FireDAC.Pooling Sample – RAD Studio Code Examples
- [WayBack] connection pooling and open connections / on embarcadero.public.delphi.database.firedac / NNTP Conversation
- [WayBack] Using Semaphores in Delphi, Part 2: The Connection Pool
- [WayBack] Google Code Archive – delphipooling
- [WayBack] Database connections in a multithreaded application | Devart Forums
In the .NET world, I take these things for granted, and it looks like ADO already does it out of the box as well:
- [WayBack] Question Regarding ADO Connection Pooling – delphi
- [WayBack] delphi – TADoConnection and pooling – Stack Overflow
- [WayBack] Connection Pooling – Mastering Delphi – Advanced Delphi Programming
–jeroen
via: [WayBack] Is there a Delphi library that allows for pooling of TCustomConnection… – Jeroen Wiert Pluimers – Google+






