uPortal 4.0 Manual

Skip to end of metadata
Go to start of metadata

uPortal Default Database Configuration

uPortal is configured to use a file-based HSQL database by default. This database configuration is not suitable for production deployments and best used for testing purposes.

uPortal does support a number of popular production-class databases and you can configure the database by following the examples posted under uPortal Production Database Configuration.

Step 1: Configure the Database Filter     

     1. In the filters folder, locate the default local.properties file under uPortal-4.0.x/filters/local.properties and configure the Database Connection Settings

uPortal/filters/local.properties

Step 2: Deploying the database driver (4.0.x and earlier)

In addition to configuring the database connection information, changing uPortal databases also requires updating the deployed database driver.

This driver may be configured as a dependency in the main uPortal pom.xml file.

Approach 1: Add separate dependency to your chosen database (recommended)

Use this approach if you want to use HSQLDB for a local, developer database but have a different database in your shared dev/test/prod systems.

  1. Search all pom.xml files in the entire project for the string "${jdbc.groupId}" and ADD your chosen database dependency under the generic ${jdbc.groupId} dependency.  The example below uses mysql.

If your installation has any non-bundled portlets (portlets not in uportal-portlets-overlay folder) that do database operations, also add the dependency to those portlet's pom.xml files.

Approach 2: Modifying the jdbc.* property values

Use this approach if you are not using HSQLDB for your local, developer database.

1. From the uPortal source directory, open the /uPortal-4.x.x/pom.xml file and add the following dependency:

 

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.25</version>
</dependency>

 

If your installation has any non-bundled portlets (portlets not in uportal-portlets-overlay folder) that do database operations, also add the dependency to those portlet's pom.xml files. 

2. Also, edit the jdbc settings in the pom.xml to replace hsqldb with your chosen database (mysql in example below).

 

Step 3: Testing the database configuration

To test your database configuration from the command-line:

uPortal Production Database Configuration

Select the database below for notes and examples of configuration.

 

Additional References

Having problems with these instructions?

Please send us feedback at uportal-user@lists.ja-sig.org

  • No labels