Delphi / Object Pascal · Database exception

EFDDBEngineException Exception (FireDAC)

What does EFDDBEngineException Exception (FireDAC) mean in Delphi / Object Pascal?

Raised for FireDAC errors that originate from the DBMS itself - a failed SQL statement, a constraint violation, or a connection drop. It carries an Errors collection of TFDDBError objects, one per error/warning/message from the DBMS operation, a DBMS-independent Kind classification, and the failing SQL and Params. Each FireDAC driver implements its own descendant with driver-specific extra properties.

EFDDBEngineException Exception (FireDAC)Delphi (VCL) · Delphi (FireMonkey) · Delphi (FireDAC)

Condition

Raised for FireDAC errors that originate from the DBMS itself - a failed SQL statement, a constraint violation, or a connection drop. It carries an Errors collection of TFDDBError objects, one per error/warning/message from the DBMS operation, a DBMS-independent Kind classification, and the failing SQL and Params. Each FireDAC driver implements its own descendant with driver-specific extra properties.

Fix

Use the Kind property to branch on DBMS-independent categories, such as connection lost versus constraint violation, instead of parsing vendor-specific error text, and inspect Errors for the full chain when a single DBMS operation reported more than one problem.

Related database exception