Persistent conexion
lazarus / 16-Databases

----------------------------------------------------------------------
cpalx · 2010-10-25 09:58

Hello

how can i make a persitent conextion, i mean i have a application
which connects to PostgreSQL database, but if the application i open
for ~30min the connection loses and of course the application crash.

how can it solve it?

i use Zeos 6.6.6 and postgresql 8.4. The roblem iss in all platforms
and i tested in a lot of lazarus version since 0.9.28 until last svn

----------------------------------------------------------------------
xenblaise · 2010-10-25 13:32

I'm sure, the error is not from PostgreSQL database.

try SQLdb instead of Zeos,
test the connection just like you did in zeos

if connection still gets the error?, then the problem is in your code.
if no errors?,  zeos has the problem.

----------------------------------------------------------------------
cpalx · 2010-10-25 16:24

Plop!  jajjaja well i dont know where is my wrong code, is just a
connection that lost it if you do nothing for a time [~30min]

----------------------------------------------------------------------
xenblaise · 2010-10-25 18:05

look out for;
Quotehot standby

http://wiki.postgresql.org/wiki/Hot_Standby