AnsweredAssumed Answered

trial 1.7 with PostgreSQL SQL error

Question asked by bora@post.cz on Dec 2, 2017
Latest reply on Dec 5, 2017 by ryandawson

Hi, sorry, a newbie here, but I cannot find an answer elsewhere. I am trying to play with the APS 1.7 and when trying to use the activiti-app with postgresql (9.6) i get an error when the engine tries to prepare the schema, saying "SQL error in statement update USER set account_type = 1" (typing from my head, so maybe not precise, but in this sense, definitely update USER). I tried to check several times for the correct hibernate dialect set to PostgreSQL. "update USER" is indeed not a valid postgresql statement. 

I switched the DB to mysql and there is works just fine, also no issue with running the admin db on postgresql.

 

Might this be an issue or do I have the dialect still wrong somewhere?

 

Bora

Outcomes