Update your Hibernate configuration

The Hibernate configuration file specifies driver and connection information, as well as dialects and how to handle connection closes and timeouts. You must have the latest version of this file for password encryption to work.

Perform the following steps to update the Hibernate configuration file for Pentaho 9.3.

1. Stop the Pentaho Server.

2. Navigate to the pentaho/server/pentaho-server/pentaho-solutions/system/hibernate directory.

3. Perform the following action depending on whether you have previously customized the hibernate.cfg.xml file for your database type:

   • If you have not customized the hibernate.cfg.xml file, replace the existing version of the file with the hibernate.cfg.xml.merge.post-upgrade file. The hibernate.cfg.xml.merge.post-upgrade file is the 9.3 version of the file.

   • If you have customized the hibernate.cfg.xml file before upgrading and you have not yet applied these customizations to the 9.3 version of the file, merge your customizations into the hibernate.cfg.xml file. See Apply customizations for instructions.

4. Restart the server and confirm no errors occurred.

   Depending on the error, you may need to contact your customer support representative for help.

Hibernate now has the Pentaho 9.3 version of this file for password encryption to work.

After setting up Tomcat, Quartz, and Hibernate to work with password encryption, you can now use encrypted passwords with Pentaho 9.3 products. See Use password encryption with Pentaho for instructions.