Automatic database refresh and disconnection reconnection |
For the published database type and workspace, iServer supports automatic refresh and reconnection. Please refer to the following table for details:
| Data source/workspace | Publishable enginetype | Whether automatic refresh is supported | How to Configure Automatic Refresh | Automatically Refreshed Content | Whether to support disconnection and reconnection | How to Configure disconnection and reconnection |
| database type | Oracle | Yes | You can configure refreshDatasource parameter to turn on the refresh database. | Support the addition and deletion of refresh dataset; do not support the modification of refresh data set and the addition, deletion and modification of field. | Yes | The iServer always opens a database disconnect reconnection. You can configure checkDatasourceConnectionInterval parameter to set the interval checking if the database is down |
| Microsoft SQL Server | ||||||
| DM | ||||||
| MongoDB | ||||||
| file workspace | Oracle | Yes | 1) iServer always enables automatic refresh of file workspace; For database type, you can configure refreshDatasource parameter to turn on the refresh database. |
1) Support all addition, deletion and modification related to data source and map for workspace; 2) The data source supports the addition and deletion of the refresh data set; it does not support the modification of the refresh data set and the addition, deletion and modification of the field. |
Yes | The iServer always enables file workspace and database disconnection reconnection. 1) The time interval for checking whether the file workspace is disconnected is 30 seconds. 2) For the database, you can configure checkDatasourceConnectionInterval parameter to set the time interval to check if the database is down. |
| Microsoft SQL Server | ||||||
| DM | ||||||
| MongoDB | ||||||
| Database type workspace | Oracle | Yes | The iServer always turns on automatic refresh of the database-based workspace. | Support the addition, deletion and modification of all data sources and maps. | Yes | The iServer always opens a database disconnect reconnection. You can configure checkDatasourceConnectionInterval parameter to set the time interval to check if the database is down. |
| Microsoft SQL Server | ||||||
| DM | ||||||
| PostgresSQL |
Note: 1. When you need to refresh the modification of the data set and the addition, deletion, and modification of fields, you can use the workspaceReload interface refreshes the specified data source or data set, or click the refresh button of the corresponding workspace in the 【workspace】 page to refresh all data sources in the workspace, and synchronize the addition, deletion and modification of data sets and fields.
2、The MongoDB tile library only supports disconnection and reconnection.