Hi, does anybody know how to set up a connection pool using DBX Driver for PostgreSQL (via dbxconnections.ini + dbxdrivers.ini or via code)?
I'm using Delphi 2009 + Devart PostgreSQL DBX4 Driver (sigle developer licence) + PostegreSQL 8.3 and I have 1 TSQLConnection per remote server, but if I have dozens of client apps connected to the server, I think I should have to pooling my SQLConnection.
Thanks in advance,
Reginaldo Francisco - |Brasil
Connection Pool
You can enable the connection pooling in the following way:
Set the Driver property for TSQLConnection component in Object Inspector. Click on the plus sign beside the Driver property. You will see two subproperties: DelegateName and DelegateConnection. Select DBXPool for the DelegateConnection property. This will enable pooling. Then you can open subproperties for DelegateConnection, and edit properties of the connection pool.
Set the Driver property for TSQLConnection component in Object Inspector. Click on the plus sign beside the Driver property. You will see two subproperties: DelegateName and DelegateConnection. Select DBXPool for the DelegateConnection property. This will enable pooling. Then you can open subproperties for DelegateConnection, and edit properties of the connection pool.