Update the Loftware DaVinci Password

If you want to change the Loftware DaVinci database user password in the database after DaVinci is installed, you can use the following steps to update the password on the Spectrum Application Server.

1. On the Spectrum Application Server, navigate to
   <SPECTRUM_HOME>\product\conf.
2. Change the password of the Loftware DaVinci user in Oracle or PostgreSQL.
3. Open the jdbc.properties file in a text editor.
4. Comment out the password for the DaVinci user, and then save and close the file.

   Example

   # This property sets the davinci user's password
   # com.loftware.schema.davinci.user.password=examplepassword

5. Open the database.properties file in a text editor.
6. Add the new DaVinci user password, and then save and close the file. This must be prefixed by either "(encrypt)" or "(clear)" depending on whether the password is in clear text or is encrypted.

   Examples

   database.password=(encrypt)examplepassword

   database.password=(clear)examplepassword

   Note: When an unencrypted password is used, you may see the following message in the spectrum.log file. This message can be ignored and will not affect your Spectrum environment.
   get error:
javax.crypto.BadPaddingException: Given final block not properly padded.

7. Restart the Loftware Spectrum service.