QSqlquery exec timeout
-
wrote on 17 Nov 2019, 19:47 last edited by BartoszPaj
Hi,
I would ask you to know about possibile set timeout for exec query.
When I lost connection before exec prepared query, process is blocked and waits for connection. Is possible to set timeout for query.exec()?
I tried set QSqlDataBase::setConnectionsOptions("timeout=10") but it doesn't work.P.S:
I'm using PostgresSQL -
wrote on 17 Nov 2019, 20:01 last edited by
Hello!
You can try set it to auto reconnect:
QSqlDataBase::setConnectOptions("MYSQL_OPT_RECONNECT=TRUE");.MYSQL_OPT_RECONNECT (argument type: bool *) Enable or disable automatic reconnection to the server if the connection is found to have been lost. Reconnect is off by default; this option provides a way to set reconnection behavior explicitly.More information is available here: https://dev.mysql.com/doc/refman/8.0/en/mysql-options.html
Happy coding! -
wrote on 18 Nov 2019, 07:37 last edited by
Hello,
thanks, but I'm using PostgresSQL. -
wrote on 18 Nov 2019, 07:46 last edited by
Hi,
Sure use 'SET statement_timeout = 30' for 30 milliseconds.
This a function provided by Postgresql -
wrote on 19 Nov 2019, 09:40 last edited by
Process still block, when I lost connection.
5/5