Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » SQL statements timeout in Linux (bug?)
Re: SQL statements timeout in Linux (bug?) [message #50415 is a reply to message #50414] Wed, 24 October 2018 12:27 Go to previous messageGo to previous message
Oblivion is currently offline  Oblivion
Messages: 1093
Registered: August 2007
Senior Contributor
Hello Giorgio,

AFAIK, if you need to set the connection timeout value, you need to do it when opening a session.
E.g.
my_postgre_session.Open("host=localhost dbname=test user=test password=test connection_timeout=1000");


OTOH, if you need to set a timeout for queries (statemenst, etc.) there is a statement_timeout parameter which can only be called after a successful Open().

You should "SET" it manually.
E.g.
 SET statement_timeout = 5000


For more details about statement_timeout, see: https://www.postgresql.org/docs/9.4/static/runtime-config-cl ient.html


Best regards,
Oblivion

Github page: https://github.com/ismail-yilmaz
upp-components: https://github.com/ismail-yilmaz/upp-components
Bobcat the terminal emulator: https://github.com/ismail-yilmaz/Bobcat

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to manage the access to a Db on an unstable connection
Next Topic: [SOLVED] How to join two tables from two schemas with SqlExp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Sat May 04 04:31:12 CEST 2024

Total time taken to generate the page: 0.06240 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.5.
Copyright ©2001-2013 FUDforum Bulletin Board Software