I am programming an offline servoy solution which will have an offline and online status.
It would be nice, if the state of the network setting changed during normal use to be able restore the remote database link from a script or button.
Is there a database command in servoy that reloads the dataproviders, in a similar way to a restart?
Thanks
David
There is no such command right now, Servoy doesn’t like loosing it’s connection to the database.
If you want this to be investigated, you can add a feature request in the Support System.
Another approach is to let your offline clients have a local database and look into the synchronization capabilities of your database. (for example Sybase mobilink)
Hi
This can be made to work but does require a polling feature to check the live status of the connection. Essentially by checking for a connection to the remote server as a boolean, you can then use the switch server feature of Servoy to change from one db to another ie remote to local and vice verse. At this point it is then possible to sync the data.
As another option I did hear that you can set MySQL into a multiple master configuration where each database is effectively the master and the slave. IF you had limited clients you could then configure each client to be a master/slave and when they re connect MySQL would handle the sync for you. I have no idea whether this would work and I guess you need to get a MySQL DBA to confirm.
One issue we did encounter was polling MySQL threw up a “too many connections” error so if you do decide to use this method make sure you poll port 80.
HTH
Gordon