topic trial 1.7 with PostgreSQL SQL error in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/trial-1-7-with-postgresql-sql-error/m-p/12156#M5374 <HTML><HEAD></HEAD><BODY><P>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.&nbsp;</P><P>I switched the DB to mysql and there is works just fine, also no issue with running the admin db on postgresql.</P><P></P><P>Might this be an issue or do I have the dialect still wrong somewhere?</P><P></P><P>Bora</P></BODY></HTML> Sat, 02 Dec 2017 08:17:06 GMT bora 2017-12-02T08:17:06Z trial 1.7 with PostgreSQL SQL error https://connect.hyland.com/t5/alfresco-forum/trial-1-7-with-postgresql-sql-error/m-p/12156#M5374 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 fro Sat, 02 Dec 2017 08:17:06 GMT https://connect.hyland.com/t5/alfresco-forum/trial-1-7-with-postgresql-sql-error/m-p/12156#M5374 bora 2017-12-02T08:17:06Z Re: trial 1.7 with PostgreSQL SQL error https://connect.hyland.com/t5/alfresco-forum/trial-1-7-with-postgresql-sql-error/m-p/12157#M5375 <HTML><HEAD></HEAD><BODY><P>Each APS release is tested against the supported databases including Postgres. I think it is tested against 9.4 but I would expect 9.6 to work as there shouldn't be breaking changes between those versions. I'd expect you to need to set these properties:</P><P></P><P><SPAN style="background-color: #ffffff;">hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect</SPAN></P><P><SPAN style="background-color: #ffffff;">datasource.driver=org.postgresql.Driver</SPAN></P><P><SPAN style="background-color: #ffffff;">datasource.url=</SPAN></P><P></P><P><SPAN style="background-color: #ffffff;">You'll also need to have the driver available - it should work with version&nbsp;</SPAN>9.4.1208.jre7 of the driver. I assume you're using tomcat and java7, otherwise you would need a different driver version.</P></BODY></HTML> Tue, 05 Dec 2017 13:27:24 GMT https://connect.hyland.com/t5/alfresco-forum/trial-1-7-with-postgresql-sql-error/m-p/12157#M5375 ryandawson 2017-12-05T13:27:24Z