Install JDBC driver as a module in JBoss

If you installed the Pentaho Server using the manual installation method, then you specified data connections to your JBoss web application server. If you want to modify existing connections or add more connections, perform the following tasks.

1. Create module file for Pentaho Repository database

2. Create module file for HSQL database

3. Create module file for H2 database

4. Define JNDI database connection information in JBoss

5. Remove JNDI resource references in JBoss

6. Update JNDI data source references to conform to JBoss standards

In JBoss, JDBC driver information is stored in a module, which is an XML file that you create. You must download the JDBC driver software component to the correct directory, then create module.xml files for each database. The JDBC drivers reference has a list of supported drivers.