Liferay 7 CE: How to add support for Oracle DB

How to add support for Oracle Database to Liferay 7 CE
How to add support for Oracle Database to Liferay 7 CE
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Those who follow Liferay is aware of the fact that the Community Edition version 7 of Liferay, were eliminated quite a bit of components App Server, Database & Clustering Support. For more detail information you can read the blog post by Bryan Cheung published on April 7, 2016.

  • The Liferay 7 CE GA no more support OOTB (Out Of The Box):
  • Application Server: Oracle WebLogic, IBM WebSphere
  • Clustering
  • MultiVM Cache
  • Oracle Database, Microsoft SQL Server, IBM DB2, Sybase DB

This sample project demonstrates how to add support to the Oracle database. Liferay has performed refactoring the code so that it is possible and easy to add support for databases no longer supported OOTB.

Attention update: The driver works with the release GA1, GA2, GA3 and GA4 of the Liferay 7 CE.

In the following video, I will guide you step-by-step instructions on how to add support for Oracle Database to Liferay 7 Community Edition in the bundled version of Wildfly.

1. Introduction

To extend support to other databases, Liferay has decided to refactory code to use Java SPI (Service Provider Interface). SPI is the mechanism that allows you to extend/change the behavior within a system without changing the source. It includes interfaces, classes or methods that the user extends or implements in order to obtain a certain functionality.

In short we must:

The following code shows how service providers are loaded via SPI.

To register your service provider, you create a provider configuration file, which is stored in the META-INF/services directory of the service provider’s JAR file. The name of the configuration file is the fully qualified class name of the service provider, in which each component of the name is separated by a period (.), and nested classes are separated by a dollar sign ($).

The provider configuration file contains the fully qualified class names (FQDN) of your service providers, one name per line. The file must be UTF-8 encoded. Additionally, you can include comments in the file by beginning the comment line with the number sign (#).

Our file is called com.liferay.portal.kernel.dao.db.DBFactory and contain the FQDN of the class it.dontesta.labs.liferay.portal.dao.db.OracleDBFactory

In the figure below shows the complete class diagram for OracleDB.

Class Diagram for add support Oracle DB

Figure 1 – Class Diagram for add support Oracle DB

2. Build project

Requirements for build project

  1. Sun/Oracle JDK 1.8
  2. Maven 3.x (for build project) or Gradle 2.x

The driver that adds support for Oracle database is a jar liferay-portal-oracledb-support-${version}.jar which then will be installed in $LIFERAY_HOME/$TOMCAT_HOME/webapps/ROOT/WEB-INF/lib (for apache tomcat). You can download the binary jar liferay-portal-oracledb-support-1.0-SNAPSHOT.jar, by doing so you can avoid doing the build.

To generate the driver for Oracle database just follow the instructions below.

the build process create the jar liferay-portal-oracledb-support-1.0-SNAPSHOT.jar inside the (maven) target directory. If you have a Gradle build system, then you can build jar by the following command

the build process create the jar inside the build/libs directory.

3. Install Liferay CE 7 on Oracle Database

To install Liferay on Oracle you must have previously configured a schema for Liferay on an Oracle instance (including Oracle XE 11gR2).

I have used an Oracle XE 11gR2 installation on CentOS 6.2 created on the fly on VirtualBox.

The parameters of my Oracle instance are:

  • Username: liferayce7
  • Password: liferay12345
  • FQDN: oracledb.vm.local (IP: 192.168.56.101)
  • TCP/IP Port: 1521
  • SID: XE

For the installation of Liferay follow the following steps (ref to install Liferay bundle on Liferay Developer Network):

  1. Download Liferay CE 7 GA1 Tomcat Bundle from sourceforge.net
  2. Extract the Liferay bundle (in my case $LIFERAY_HOME is /opt/liferay-portal-7.0-ce-ga1-node-1)
  3. Copy the jar liferay-portal-oracledb-support-${version}.jar in $LIFERAY_HOME/$TOMCAT_HOME/webapps/ROOT/WEB-INF/lib
  4. Download and install Oracle JDBC driver (ojdbc6.jar) in $LIFERAY_HOME/$TOMCAT_HOME/lib/ext
  5. Create the portal-ext.properties in $LIFERAY_HOME with the content as the file below. You should modify the JDBC connection parameters to the your db and the value of liferay.home
  6. Launch the Liferay Portal through the command $LIFERAY_HOME/$TOMCAT_HOME/bin/startup.sh
  7. See the Liferay activities via the log file $LIFERAY_HOME/$TOMCAT_HOME/logs/catalina.out

Below you can see the portal-ext.properties

You can see the my complete catalina.out log file and following some screenshots of DB.

Liferay 7 CE GA1 on Oracle Database

Figure 2 – Liferay 7 CE GA1 on Oracle Database

 

Liferay 7 CE GA1 on Oracle Database

Figure 3 – Liferay 7 CE GA1 on Oracle Database

4. The next step

Likewise you can also add support for other databases. The new challenge is to add the Cluster to Liferay. The operation should be feasible through the OSGi framework.

Make a donation to Antonio Musarra - PayPal.Me

Liferay Portal Security AuditCos'è e come funzione il framework di Security Audit

Vi siete mai chiesti cos'è e come funziona il sistema di Security Audit di Liferay? Ho cercato di rispondere alla domanda non soffermandomi solo al "cosè e come funziona", sono andato ben oltre. Non vi resta che leggere questo EBook per scoprire.

Ottieni il tuo EBook

Antonio Musarra

I began my journey into the world of computing from an Olivetti M24 PC (http://it.wikipedia.org/wiki/Olivetti_M24) bought by my father for his work. Day after day, quickly taking control until … Now doing business consulting for projects in the enterprise application development using web-oriented technologies such as J2EE, Web Services, ESB, TIBCO, PHP.

You may also like...

Liferay SSL/TLS SecurityCome configurare il bundle Liferay per abilitare il protocollo SSL/TLS

Sei curioso di scoprire come configurare il bundle Liferay per funzionare in modalità sicura tramite protocollo SSL/TLS? In questo eBook ( #LFRDEPGUIDE ) ti spiego come farlo step-by-step; per il bundle Apache Tomcat e WildFly. Ricorda di lasciare un tuo feedback dopo averlo letto.