Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation

Verification Checklist for JBoss Connection Tasks - DI

This checklist for JBoss connection tasks will help you verify that you have completed all items needed before starting the Pentaho DI Server.

Task Section Brief Description
1. Install JDBC Driver as a Module in JBoss Download the JDBC driver software component to the correct directory, then create module.xml files for each database.
2. Create Module File for DI Repository Create a module file for the database that hosts the DI Repository (either PostgreSQL, MySQL, or Oracle), as well as for HSQLDB.
3. Create Module File for HSQL Database Create a module file for the HSQL database. The version of HSQLDB used should be 2.3.2.
4. Create Module File for H2 Database Create a module file for the H2 database.
5. Define JNDI Database Connection Use JNDI to specify port, driver, user name, and password information for the Audit and Quartz databases in your DI Repository. 
6. Add JBoss Deployment Structure File to pentaho.war Controls class loading, prevents automatic dependencies from being added, adds dependencies, defines additional modules, changes isolated class loading behavior, and adds additional resource roots to a module.
7. Remove JNDI Resource References in JBoss Remove JNDI resource-references in the web.xml file so that the DI Server will operate properly.
8. Update JNDI Data Source Reference to Conform to JBoss Standards Update files so that referenced JNDI data sources conform to JBoss standards.
9. Enable JBoss Classloader to Load Classes from Sun JDK Configure the Pentaho Platform in JBoss by adding this list of packages.
10. Prepare JBoss Web Application Servers If you have installed the JBoss web application server, you will need to manually complete the following configuration tasks.
11. Increase the Amount of Time JBoss Allows for DI Server Deployment Since the DI Server deployment takes longer than one minute, you will need to change the default time for deployment by editing the standalone.xml file, 
12. Disable the JBoss RESTEasy Scan Disable the JBoss RESTEasy scan to load pentaho REST services correctly.
13. Set the Location of the pentaho-solutions Directory  Define the location of the Pentaho solutions directory in the web.xml file to deploy JBoss correctly. 
14. Configure JBoss Settings Modify the JBoss startup script to match the DI Server's memory resource requirements. If this step is not performed, the DI Server will not start.
15. Configure http and https Ports on JBoss JBoss needs to be configured to run with the DI Server ports.
16. Configure Fully-Qualified URL for DI Server You can change the DI Server fully-qualified URL.