Page 1 of 1

keep alive method ?

Posted: Wed 29 Jan 2014 04:13
by whit1950
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

Re: keep alive method ?

Posted: Wed 29 Jan 2014 09:55
by AlexP
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;