Connections idle timeout in Database Server Tab

Classic Servoy
1

Hi,

What exactly is the purpose of the "connections idle timeout in the Database Server Tab ?

Does this option have any effect on the connexions to the solutions ? If not, how can I set the maximum idle time for webclients ?

Thanks

Ugo

2

Ugo,

The setting is described as “Connections will be closed automatically after being idle for specified time (minutes)”.
Database connections are shared between all solutions, with this setting you can configure closing a db connection after not being used for some time.

Hope this helps,

Rob

3

Thank you Rob,

So this is uniquely related to database connexions.

Is there any other way to close idle users on the server apart frorm using the user manager plugin ?

4

Ugo,

Idle webclients are removed when their http session times out.
This can be configured in the tomcat config: /path/to/servoy/application_server/server/conf/web.xml, it defaults to 30 minutes

<session-timeout>30</session-timeout>

Rob

5

Idle webclients are removed when their http session times out.

To be more specific, the session only times out, when you close the browser, or the tab in the browser, with your session.
It does not time-out just by an idle time of 30 minutes!

The only way todo that, (afaik) is using the UserManagerPro plugin.
With Servoy going more & more to the web, this should be default implemented in Servoy IMHO
(setting it in servoy-admin page, and by scripting!)

6

If the user leaves the page, or closes the browser, it is gone.
Does it make sense to set the timeout > then 1 Second ?
What for ?

Thanks for any suggestions