keep alive method ?

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
whit1950
Posts: 2
Joined: Tue 11 Sep 2012 00:05

keep alive method ?

Post by whit1950 » Wed 29 Jan 2014 04:13

Is there a keep alive method for the postgresSQL uniconnection , or another way to keep a connection alive? I have queries that time out after 15 minutes and they are still running.

Thanks

Whit

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: keep alive method ?

Post by AlexP » Wed 29 Jan 2014 09:55

Hello,

To limit query time out, you can use the CommandTimeout property

in UniDAC

Code: Select all

  UniQuery1.SpecificOptions.Values['CommandTimeout'] := 1;
in PgDAC

Code: Select all

  PgQuery1.CommandTimeout := 1;

Post Reply