Using the Internal Derby Database with OM Web Viewer 12.1?
book
Article ID: 44206
calendar_today
Updated On:
Products
Output Management Web Viewer
Issue/Introduction
When running the ConfigTool after the install, you will be asked to choose between using the internal Derby database or an external database. The database size used by Web Viewer is small, so from the point of performance it is really no reason to prefer one or other database.
Environment
Output Management Web Viewer 12.1
MS SQL Server
IBM Db2
Oracle Database
Apache Derby
Resolution
We recommend performing the test installation with the internal Derby database (because it is easier). We recommend using the external database for production due to following reasons:
If you undeploy Web Viewer with Tomcat or Websphere, or if you uninstall Web Viewer temporarily, the internal database is deleted during this process. So you have to remember you should back up the database folder or export your repositories, users, preferences etc. before undeploying or uninstallation, otherwise you have to define them manually after you deploy or install Web Viewer again. The external database would remain in these instances.
The internal Derby database can not be used when you scale your Web Viewer installation to run on additional application servers (e.g. when you have a lot of users or when you have users in long-distance regions). In that case you have to use an external database or to guarantee mirroring of internal databases on all Web Viewer servers.
You cannot turn off the database error messages that are displayed when bringing up Web Viewer when you have internal Derby.