User Data Repository - SuperWEB2
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 HyperSQL database to store the UDR, but this is only really suitable for demonstration use. For production use, you should replace the default database with a higher volume relational store such as MySQL or an Oracle database.
Overview of Required Steps
To replace the default database, you need to:
- Configure the Relational Database System (RDMS) of your choice by setting up:
- A new empty database for use by the UDR
- A user account that SuperWEB2 will use to write to the UDR; this account must have permissions to write to the UDR database
- 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: