The reference implementation of uPortal's data storage interfaces requires a relational database. uPortal provides a tool, DbLoader, to load a relational database with the required uPortal tables and sample data.
DbLoader performs the following tasks:
- Reads in properties/db/tables.xml file to determine the database schema
- Deletes existing tables specified in tables.xml.
- Creates the tables specified in tables.xml.
- Reads in properties/db/data.xml file to determine sample data.
- Inserts data from data.xml into the newly created tables.
- Creates a database script containing all the SQL statements previously executed.
DbLoader can be configured by modifying properties/db/dbloader.xml. Because DbLoader relies on database metadata supplied by a JDBC driver, it may be necessary (for some combinations of drivers and databases) to supply a datatype mapping inside dbloader.xml. If this is necessary, DbLoader will print an error message with instructions.