Setting Up JNDI on Tomcat

Applicable for Liferay DXP 7.4+ or Liferay Portal 7.4+

To set up JNDI resources, you must put the necessary JDBC drivers in the Tomcat lib folder (i.e. tomcat-9.0.56/lib). For example, if you use an Oracle database, copy ojdbc8.jar into this folder. If you use the Hikari Connection Pool, you must copy the hikaricp.jar and slf4-api.jar files as well.

After copying the necessary files, define your JNDI resources. Add the definition to a ROOT.xml file or a server.xml file. Then add a resource link to a context.xml file.

Setting the ROOT.xml or server.xml

For example, modify the tomcat-9.0.56/conf/Catalina/localhost/ROOT.xml file:

<?xml version="1.0" encoding="UTF-8"?>

<Context crossContext="true">
	<JarScanner className="com.liferay.support.tomcat.util.scan.NOPJarScanner" />

	<Manager pathname="" />

	<Resource name="jdbc/liferay" auth="Container"
		factory="com.zaxxer.hikari.HikariJNDIFactory"
		type="javax.sql.DataSource"
		minimumIdle="5"
		maximumPoolSize="10"
		connectionTimeout="300000"
		driverClassName="oracle.jdbc.OracleDriver"
		jdbcUrl="jdbc:oracle:thin:@192.168.1.213:1521/liferay"
		dataSource.user="liferay"
	dataSource.password="password" />
</Context>

Or define the data source in your /conf/server.xml file within the GlobalNamingResources element. For example,

<GlobalNamingResources>

<Resource name="jdbc/liferay" auth="Container"
		factory="com.zaxxer.hikari.HikariJNDIFactory"
		type="javax.sql.DataSource"
		minimumIdle="5"
		maximumPoolSize="10"
		connectionTimeout="300000"
		driverClassName="oracle.jdbc.OracleDriver"
		jdbcUrl="jdbc:oracle:thin:@192.168.1.213:1521/liferay"
		dataSource.user="liferay"
	    dataSource.password="password" />

</GlobalNamingResources>

Setting the context.xml

Define a ResourceLink in your /conf/context.xml file. For example,

<ResourceLink name="jdbc/liferay" global="jdbc/liferay" type="javax.sql.DataSource" />

Setting the Portal Properties

In your portal-ext.properties file, use the JNDI reference: jdbc.default.jndi.name=jdbc/liferay.