The User Data Repository (UDR) is designed to allow SuperWEB2 users to save their own table design definitions so they can use them again the next time they login.
The default installation of SuperWEB2 uses an embedded H2 database to store the UDR, but this is only suitable for demonstration use. Some features are not supported with the embedded H2 database. For production use, you must replace the default database with a higher volume relational store such as SQL Server, MySQL or Oracle.
Overview of Required Steps
To replace the default user data repository, you need to:
- Configure the Relational Database Management System (RDBMS) of your choice:
- Create a new empty database for use by the UDR
- Create a user account that SuperWEB2 will use to write to the UDR; this account must have permissions to write to the UDR database
- Ensure that the database connection pool configured in your RDBMS is set to an appropriate value. Learn more.
- Install an appropriate JDBC driver for your RDBMS, so that SuperWEB2 can communicate with the UDR database.
- Configure the data source in the Tomcat instance hosting SuperWEB2:
- Configure the JNDI resource in <tomcat_home>\conf\server.xml
- Create the resource link in <tomcat_home>\conf\context.xml
- Start SuperWEB2 (this will create the empty UDR tables in your new database).
The following sections describe in detail how to set up the UDR for different database systems: