Postgresql configuration error

Camunda 7 Topics Discussion & Questions
,
1

hi,
i want to use Tomcat 9.0.24 with PostgreSQL 11.2.
I put postgresql-42.2.8.jar file in the lib folder.
I made the following change in server.xml

<Resource name="jdbc/ProcessEngine"
              auth="Container"
              type="javax.sql.DataSource" 
              factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
              uniqueResourceName="process-engine"
              driverClassName="org.postgresql.Driver" 
              url="jdbc:postgresql://localhost:5432/camunda"
              defaultTransactionIsolation="READ_COMMITTED"
              username="postgres"  
              password="postgres"
              maxActive="20"
              minIdle="5"
              maxIdle="20" />

then start tomcat. Everything worked fine. db tables created automatically.
After closing the tomcat. changed bpm-platform.xml

<properties>
      <property name="history">full</property>
      <property name="databaseSchemaUpdate">false</property>   
      <property name="authorizationEnabled">true</property>
      <property name="jobExecutorDeploymentAware">true</property>
      <property name="historyCleanupBatchWindowStartTime">00:01</property>
    </properties>

tomcat gives the following error on startup.
catalina.2020-03-20.log (21.9 KB)

if i don’t the change bpm-platform.xml.

<properties>
      <property name="history">full</property>
      <property name="databaseSchemaUpdate">true</property>   
      <property name="authorizationEnabled">true</property>
      <property name="jobExecutorDeploymentAware">true</property>
      <property name="historyCleanupBatchWindowStartTime">00:01</property>
    </properties>

tomcat gives the following error on startup.
catalina.2020-03-20.log (71.4 KB)

after that i tried to change database name , same errors happens again.

2

if someone else encounters this error in the future. the problem is my windows locale. setting jvm parameteres -Duser.country=US -Duser.language=en is solved my problem.

2 Likes
3

Thanks for posting your solution.

4