Configure the Database

uPortal Database Configuration

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

uPortal does support a number of popular production-class databases.

Configuring the database

The main database properties (url, user, etc.) may be configured through uPortal's rdbm.properties file.

Sample HSQL configuration of uportal-impl/src/main/resources/properties/db/rdbm.properties

##### Hypersonic SQL - Server mode
##### Requires first starting Hypersonic SQL with the command:
##### "ant hsql"
hibernate.connection.driver_class=org.hsqldb.jdbcDriver
hibernate.connection.url=jdbc:hsqldb:hsql://localhost:8887
hibernate.connection.username=sa
hibernate.connection.password=
hibernate.dialect=org.hibernate.dialect.HSQLDialect

Deploying the database driver

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.

<!-- The JDBC Driver used by uPortal -->
<jdbc.groupId>hsqldb</jdbc.groupId>
<jdbc.artifactId>hsqldb</jdbc.artifactId>
<jdbc.version>${hsqldb.version}</jdbc.version>

Testing the database configuration

To test your database configuration from the command-line:

ant dbtest

Database-specific notes and examples

Having problems with these instructions?

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