ECM Environment Variables

Following are the environment variables used in the ecm service. ECM can is compatible with MSSQL and MySql as well. Please change the variables according to the database used. 

If MSSQL is used, create The database first with the name of "ecm" on the database server.


Config Parameter

Expected Value

Notes

ECM_DB_DIALECT



For MySQL: org.hibernate.dialect.MySQL5InnoDBDialect

For MSSQL: org.hibernate.dialect.SQLServer2008Dialect

Dilect for MySQL and MSSQL


ECM_DB_DRIVER



For MySQL: com.mysql.jdbc.Driver

For MSSQL: net.sourceforge.jtds.jdbc.Driver

Driver used for MySQL and MSSQL

ECM_DB_PASS

root

Database user. If you are using MSSQL, set the user who have permission on the database

ECM_DB_URL

for MySQL: jdbc:mysql://mysql:3306/ecm

for MSSQL: jdbc:jtds:sqlserver://<FDQN>:<Port>/ecm


ECM_DB_USER

root


TZ

Time zone where solution is being deployed.

e.g. "Europe/Zurich" if solution is deployed in Switzerland. See what is your time zone.