How it works...

As already mentioned, we have to access the database using a connection pool. FireDAC has the concept of connection definition. A connection definition describes how to store and use FireDAC connection parameters, and what a connection definition means. To specify connection parameters, an application must use a connection definition. The connection definition is a set of parameters. Depending on the kind of connection definition, a connection may also be pooled.

FireDAC supports three definition types:

Connection

Definition

Temporary

This has no name, is not stored in a connection definition file, and is not managed by the FDManager. It is defined directly on TFDConnection component, and cannot be used as pooled. ...

Get Delphi Cookbook - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.