U++ forum: Welcome to the forum

Re: How to manage the access to a Db on an unstable connection [message #50400 is a reply to message #50398]

Tue, 16 October 2018 21:24

Zbych
Messages: 327
Registered: July 2009

Senior Member

There is no need to open/close connection every time you want to fetch some data or update the database. You simple need to handle database errors correctly. When connection is lost you should catch exception, analyse error and try to reconnect if connection is lost. Also all inserts/updates can be surrounded by begin/commit/rollback and if you loose connection postgress will automatically drop unfinished inserts/updates.
Just check functions: ConnectionOK, ReOpen and callback WhenReconnect

https://github.com/ultimatepp/mirror/blob/master/uppsrc/Post greSQL/PostgreSQL.h

Report message to a moderator