First time here? Check out the FAQ!
asked 2012-08-05 14:48:05 +0200Python
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)
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
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-05 14:48:05 +0200
Seen: 138 times
Last updated: Aug 05 '12