Ask Your Question
2

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

asked 2012-08-05 14:48:05 +0200

Python gravatar image

updated 2012-08-12 13:59:42 +0200

tohuwawohu gravatar image

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)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-04-28 02:25:42.737342

Comments

1

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 ?

Python gravatar imagePython ( 2012-08-05 17:19:29 +0200 )edit

@Python -- Still looking for an answer here?

qubit gravatar imagequbit ( 2013-03-13 11:45:39 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2012-08-05 15:47:03 +0200

hyogapag gravatar image

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

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-08-05 14:48:05 +0200

Seen: 1,027 times

Last updated: Aug 05 '12