Set up JNDI on Pentaho Data Integration Server

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

In the pentaho infocenter http://infocenter.pentaho.com/help/index.jsp 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

       <resource-ref>
       <description>Hibernate</description>
       <res-ref-name>jdbc/hibernate</res-ref-name>
       <res-type>javax.sql.DataSource</res-type>
       <res-auth>Container</res-auth>
       </resource-ref>

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
Tags:
Created by Julia Gusman on 2012/05/25 19:00

XWiki Enterprise 3.5.1 - Documentation