Changing database of eHour standalone

By default the standalone version of eHour 0.9.1 uses an embedded database to store timesheet information. This works well but it's not guaranteed to recover after a power failure, crash, etc. When you use eHour in a production environment it's recommended to use MySQL or PostgreSQL as your database.

Using MySQL

Open the conf/ehour.properties file and set the ehour.database to mysql:

ehour.database=mysql

Remove the hashmarks (#) and replace the database name and username/password with appropiate values

# for mysql uncomment the following lines (and make sure postgresql lines below are commented out)
ehour.database.driver=com.mysql.jdbc.Driver
ehour.database.url=jdbc:mysql://127.0.0.1:3306/ehour?zeroDateTimeBehavior=convertToNull&useOldAliasMetadataBehavior=true
ehour.database.username=sa
ehour.database.password=sa

Make sure the configuration for postgresql is commented out (prefixed with #)

Create the database tables by following the instructions on database setup for Linux or Windows

Restart eHour

Using Postgresql

Open the conf/ehour.properties file and set the ehour.database to postgresql:

ehour.database=postgresql

Remove the hashmarks (#) and replace the database name and username/password with appropiate values

# for postgresql uncomment the following lines (and make sure mysql lines above are commented out)
ehour.database.driver=org.postgresql.Driver
ehour.database.url=jdbc:postgresql://localhost:5433/ehour
ehour.database.username=sa
ehour.database.password=sa

Make sure the configuration for mysql is commented out (prefixed with #)

Create the database tables by following the instructions on database setup for Linux, Windows setup instructions are not available.

Restart eHour

Change database

Changing database of eHour standalone

Using MySQL

Using Postgresql