By default eHour standalone uses an embedded database to store timesheet informationdata. This works well but it's not guaranteed to recover after an unforeseen shutdown such as a crash or power failure. When you use eHour in a production environment it's recommended to use MySQL or PostgreSQL as your database.
On Windows you need to stop the eHour or Tomcat service first before you can edit the configuration file.
Open the configuration file (
conf/ehour.properties) file and set the value of ehour.database to mysql:
Remove the hashmarks hashtags (#) and replace the database name and username/password with appropiate values
conf/ehour.properties file and set the ehour.database to postgresql: