The default installation of SuperWEB2 uses an embedded HyperSQL database to store the UDR, but this is only suitable for demonstration use. For production use, you must 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 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: