force logout

Classic Servoy
1

hi!

is there a way to send message can send message from solution A to solution B?

the scenario is this. if solution B is accessing tableA record 1. users who are currently logged in solutionA that is also accessing tableA record 1 will be sent a warning to logout then force them to logout.

2

according to wiki http://wiki.servoy.com/display/public/DOCS/maintenance

The Maintenance plugin is only available to the code being executed inside the pre and post import hooks. The plugin can not be used in normal clients

what does “normal clients” mean? I have a web service that does a restore of a database(full or partial). We would like the clients accessing the solution be notified that a restore is ongoing and thus will be disconnected. Based on wiki, the maintenance plugin will not work for this requirement.

I am welcome to suggestions.

3

has anyone used the maintenance plugin in their solution?

4

as the doc says you should only use the maintenance plugins in the pre en post import hooks that you define on a solution when they are imported in a server.

normal clients what ever they are shouldn’t use it It should only be used when you import a solution.

5

jcompagner:
as the doc says you should only use the maintenance plugins in the pre en post import hooks that you define on a solution when they are imported in a server.

normal clients what ever they are shouldn’t use it It should only be used when you import a solution.

i see. hope you can share what are the side effect of using the maintenance plugin? thanks!

6

some things like access the server/tables really shouldn’t be done in a client
and most calls completely don’t work in a smart client
it is just that that it is not meant for real client usage.

7

jcompagner:
some things like access the server/tables really shouldn’t be done in a client
and most calls completely don’t work in a smart client
it is just that that it is not meant for real client usage.

ok. would you have any suggestion how will I be able to create a table at runtime and access it using a databaseManager.getFoundset and drop the table after the entire process?

regards,
rogel

8

use:
databaseManager.createDataSourceByQuery(xxx)

or

JSDataSet.createDataSource()

to create a temp table that you can then (pre)fill

9

jcompagner:
use:
databaseManager.createDataSourceByQuery(xxx)

or

JSDataSet.createDataSource()

to create a temp table that you can then (pre)fill

Thanks Johan. The datasource is stored in memory? I have 150+ tables to restore data
here is the process.

  1. restore the xml data into the temp tables
  2. delete the data from the main table
  3. insert from the temp tables
10

it is stored in memory and backed with a temp table

11

jcompagner:
it is stored in memory and backed with a temp table

given the number of tables and possible large data, is the createdatasource your recommended option?

12

its the only option if you want to create tables that you want to access through the foundset.