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 Pentaho 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. |