This sample demonstrates how to connect a Liferay Service Builder application to an external database via a JNDI connection. Here, an external database means any database other than Liferay DXP’s database. For this sample to work correctly, you must prepare such an external database and configure Liferay DXP to use it. Follow the steps below to make the required preparations before deploying the application.
Create the external database to which your Service Builder application will connect. For example, create a MariaDB database called
external. Add a table to this database called
Name. Add at least one record to this table. Here are the MariaDB commands to accomplish this:
create database external character set utf8; use external; create table region(id bigint not null primary key, name varchar(255)); insert into region(id, name) values(1, 'Tasmania');
Make sure that your database commands were successful: Running
select * from region;should return the record you added.
Now you need to define a JNDI connection to your database. The way this is done depends on your application server. Here we demonstrate how to specify the JNDI connection for Tomcat. First, open your
[LIFERAY_HOME]/tomcat-9.0.6/conf/server.xmlfile and add this resource element inside of the
<Resource name="jdbc/externalDataSource" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" driverClassName="org.mariadb.jdbc.Driver" url="jdbc:mariadb://localhost/external" username="yourusername" password="yourpassword" maxActive="20" maxIdle="5" maxWait="10000" />
Replace the specified username and password with the correct values for your database.
[LIFERAY_HOME]/tomcat-9.0.6/conf/context.xmlfile and add this resource link element inside of the
<ResourceLink name="jdbc/externalDataSource" global="jdbc/externalDataSource" type="javax.sql.DataSource"/>
Now your data source is defined at Tomcat’s scope.
com.liferay.blade.samples.jndiservicebuilder.service-log4j-ext.xmlin your Liferay DXP instance’s
[LIFERAY_HOME]/osgi/log4folder. Create this folder if it doesn’t yet exist. Add this content to the XML file that you created:
<?xml version="1.0"?> <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"> <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"> <category name="com.liferay.blade.samples.jndiservicebuilder.service.impl"> <priority value="INFO" /> </category> </log4j:configuration>
This XML file defines the log level for the classes in the
com.liferay.blade.samples.jndiservicebuilder.service.impl.RegionLocalServiceImplis the class that will produce log messages when the sample portlet is viewed.
Now your sample is ready for deployment! Make sure to build and deploy each of the three modules that comprise the sample application:
After these modules have been deployed, add the
jndi-web portlet to a
Liferay DXP page.
A sample table is printed in the portlet’s view, representing the info inputted into the database.
This sample demonstrates two ways to access data from an external database defined by a JNDI connection:
- extract data directly from the raw data source by explicitly specifying a SQL query.
- read data using the helper methods that Service Builder generates in your application’s persistence layer.
Once you’ve added the
jndi-web portlet to a page, the
RegionLocalServiceUtil.useJNDI method is invoked. This method accesses the
database defined by the JNDI connection you specified and logs information about
the rows in the
region table to Liferay DXP’s log.
The first way of accessing data from the external database is to extract data directly from
the raw data source by explicitly specifying a SQL query. This technique is
demonstrated by the
RegionLocalServiceImpl.useJNDI method. That method obtains
the Spring-defined data source that’s injected into the
bean, opens a new connection, and reads data from the data source. This is the
technique used by the sample application to write the data to Liferay DXP’s log.
The second way of accessing data from the external database is to read data
using the helper methods that Service Builder generates in your application’s
persistence layer. This technique is demonstrated by the
method which first obtains an instance of the
RegionLocalService OSGi service
and then invokes
are two examples of the persistence layer helper methods that Service Builder
generates. This is the technique used by the sample application to actually
display the data. The portlet’s
view.jsp uses the
<search-container> JSP tag
to display a list of results. The results are obtained by the
UseJNDI.getRegions method mentioned above.