We are using switchServer() to manage multitenant application. The application is by default connecting to a test/demo environment while using specific users is switching standard connections to the production environment using switchServer() technique. Users in this context are not Servoy managed users but application managed users.
Example: LogicalServerName > DatasourceName
Default connection at startup (demo/test company):
- kernel_data > kernel_data
- kernel_azi_data > kernel_azi_data
- firm_data > firm_data
- firm_pricing_data > firm_pricing_data
After moving with switchServer() to myComp company:
- kernel_data > kernel_data
- kernel_azi_data > myComp_firm_data
- firm_data > myComp_firm_data
- firm_pricing_data > myComp_firm_pricing_data
It is not fully clear from documentation what is automatically switching and what is not; in other words: in the standard Servoy environment which function calls/structures are aware of server switching? Which of them refers to a logical servername and which refers to a physical servername aka a datasource name?
- forms datasource
- valuelists "table values" or "related values"
- databaseManager
- plugins.rawSQL
- plugins.maintenance
- ...others...
Tnks to anyone will help to clearify what we currently see as a problem...
Gianni