LibreOffice Base - connection times out after 60 seconds, how do you keep a connection alive/reconnect without restarting ?

English
, , ,
#1

LibreOffice Base - connection times out after 60 seconds, how do you keep a connection alive/reconnect without restarting ?

I am connecting to a MySQL database that cuts the connection after 60 seconds of inactivity, how do you make LibreOffice reconnect with out restarting ? Alternatively how do you configure LibreOffice to keep the connection alive ?

Using: MySQL (JDBC)

1 Like
#2

the setting of connection pooling has no effect on the database, Please note the MYSQL server is cutting the connection not LibreOffice. How can you make it reconnect after it has been booted by the server ?

#3

See: How to make LibreOffice Base reconnect to a database

#4

@Python1 – Still looking for an answer here?

#5

Go to Tools > Options > LibreOffice Base > Connections. Activate the connection pooling and set the timeout to an higher value (max is 300 seconds).
More info there : http://help.libreoffice.org/Common/Connections#Timeout_.28seconds.29

#6

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.