Programatically flush client's cache

Classic Servoy
1

I have a script that performs an update on the backend DB once a day. After the update, Servoy does not see the changes made to the DB.

I know that I can go to the Servoy-Admin page and flush the cache of the clients. If I do this then the changes become visible in all Servoy clients.

Is there any way to flush the cache of the clients programatically? I want to fully automate the daily update process, without the need to make operations in the Servoy-Admin page.

Thanks,
Gabriel Erzse.

2

A very easy way to do this is to use something like wget/curl/fetch to get activate the flush in the servoy admin pages. This can be automated easily from a cron like service.

3

(1) Flush all clients:

http://:8080/servoy-admin/clients/flush?confirm=Flush%21

(2) Flush a particular solution. This one is a bit more interesting. First, here’s the URL format:

http://:8080/servoy-admin/solutions/flush/?mode=3

You need access to the servoy repository database (servoy_repository) from whatever scripting environment you are using. The following SQL statement will give you the id:

select solution_id from servoy_solutions where solution_name=‘<solution_name>’;