Set up JNDI on Pentaho Data Integration Server

Last modified by Harini Yalamanchili on 2014/07/11 14:36

In the pentaho infocenter it says, you should be able to add JNDI in the file .\data-integration-server\pentaho-solutions\system\simple-jndi. However, if this does not work for some reason, this is how you can use the standard tomcat method:

The files you will need to edit

  • data-integration-server/tomcat/webapps/pentaho-di/META-INF/context.xml 
  • data-integration-server/tomcat/webapps/pentaho-di/WEB-INF/web.xml

Follow the examples for hibernate

In context.xml you will need to add your connection details
<Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource"
                factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"
                maxWait="10000" username="hibuser" password="password"
                driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/hibernate"
                validationQuery="select count(*) from INFORMATION_SCHEMA.SYSTEM_SEQUENCES" />

In web.xml reference the JNDI name from the first


You will need to redeploy your webapp for this change to take place:

  • Stop Pentaho DI Server
  • Remove the data-integration-server/tomcat/conf/Catalina/localhost/pentaho-di.xml file
  • Remove the data-integration-server/tomcat/work/Catalina/pentaho-di folder(for 5.1.X the path is data-integration-server/tomcat/work/Catalina/localhost/pentaho-di)
  • Start Pentaho DI Server
Created by julia on 2012/05/25 19:00

XWiki Enterprise 3.5.1 - Documentation