IMPORTANT: As we revamp and transition our documentation to this site, you may find the articles you need on Liferay's Help Center.

Analytics Cloud Commerce DXP / Portal Liferay Cloud Reference

Documentation Menu

Highlighting

Remove Highlighting

Go Back

• Getting Started
• Site Building
• Content Authoring and Management
• Process Automation
• Using Search
• Collaboration and Social
• Users and Permissions
• System Administration
• Building Applications
• Liferay Internals
• Headless Delivery
• Installation and Upgrades
  • Installing Liferay
    • Installing a Liferay-Tomcat Bundle
    • Configuring a Database
    • Running Liferay for the First Time
    • Using Liferay Docker Images
    • Installing Liferay on an Application Server
  • Setting Up Liferay
  • Securing Liferay
  • Maintaining a Liferay Installation
  • Upgrading Liferay
  • Reference

English

• Japanese
• English

• Liferay Learn
• DXP
• Installation and Upgrades
• Installing Liferay
• Configuring a Database

Configuring a Database

By default for demonstration purposes, Liferay DXP/Portal is configured to use an embedded HSQL database. Beyond demonstration purposes, we recommend using a full-featured, supported RDBMS, such as:

• MariaDB

• MySQL

• Oracle

• PostgreSQL

Important

The Liferay DXP Compatibility Matrix lists the supported databases and versions.

Configure the database

1. Create a database that uses UTF-8. Here is a MySQL command example:

   create database lportal character set utf8;
   

2. Set up a database user with full database permissions. If your organization requires the DXP database user to have limited database access, see High Security Database User Practices.

   Important

   Liferay requires reading from and writing to the database. The Liferay database user must therefore have permissions to read and write data.

3. Install a JDBC Connector. The DXP bundle includes several open source JDBC connectors in the /lib/ext folder. Connectors for proprietary database, like Oracle or DB2 (see the table below), must be downloaded from the vendor.

Proprietary Databases:

Database	Connector	Vendor Site	Notes
Oracle	ojdbc8.jar	Oracle	The ojdbc8.jar library with at least Oracle 12.2.0.1.0 JDBC 4.2 versioning is required because of data truncation issues that have been detected reading data from CLOB columns.
DB2	db2jcc4.jar	IBM	The dbc2jcc connector has been deprecated after 3.72.

Congratulations! You configured a database for Liferay DXP.

Note

For database configuration details, see the Database Configuration Reference.

Next Steps

• Running Liferay for the First Time

Not finding what you're looking for?

Pardon our dust as we revamp and transition our product documentation to this site. If something seems missing, please check Liferay Help Center documentation for Liferay DXP 7.2 and previous versions.

Try Liferay's Help Center