/
uP101 Database Configuration

uP101 Database Configuration

Jun 01, 2006

An element of the uP101 pre-conference seminar

This page is not intended to be a general documentation of uPortal configuration. It is the specific ramblings that will be presented at the JA-SIG Vancouver uPortal 101 pre-conference seminar.

I. Start the database and verify that uPortal is configured to connect to it.

  1. Go to the demo directory under hsqldb and run the runServer script (bat or sh) with the parameter -port 8887.

    runServer -port 8887

  2. Look at rdbm.properties for the connection definition to hsqldb.  It is already set up to connect to hsqldb and includes comments for using other databases.

  3. Right click build.xml again and select the target "dbtest". This should connect to the running hsqldb you just started and print out information about the database characteristics. 

II Run "initportal"

Once again, right click build.xml and choose initportal.  This will connect to the database and intialize it.  The table definitions and data are in xml files under properties/db in the files tables.xml and data.xml.  There is one additional configuration file here, dbloader.xml, which may need to be modified for a database that uPortal has not yet encountered.  Chances are, you won't need to do anything because the required mappings for common database products are already there.