topic Important: Activiti 5.15 and MySQL 5.6+ users in Alfresco Archive

Important: Activiti 5.15 and MySQL 5.6+ users

jbarrez — Mon, 24 Mar 2014 21:28:43 GMT

Hello all,As you probably read, we released Activiti 5.15 last Friday (http://bpmn20inaction.blogspot.com/2014/03/activiti-515-released.html).Eager users have tried it out already (which is awesome!) and notified us that there is a bug when using MySQL 5.6+ and executing the upgrade scripts (for exa

Re: Important: Activiti 5.15 and MySQL 5.6+ users

pkonyves — Fri, 05 Sep 2014 13:51:32 GMT

Hi,

We just ran into the problem, that the create scripts did not work with mysql 5.1 (yes, old, but we are using it…), so we had to use the mysql55 scripts. However I did not find evidence in the Activiti code ( https://github.com/Activiti/Activiti/commit/41a01f2dd44884a22ce314a1f22f6e3ccba61adc ) that the upgrade mechanism is aware of the mysql55 scripts. The DbSqlSession#getResourceForDbOperation (https://github.com/Activiti/Activiti/blob/master/modules/activiti-engine/src/main/java/org/activiti/engine/impl/db/DbSqlSession.java#L1175) method takes the DB type, but that cannot be mysql55 (I think), only mysql. So for mysql version < 5.6 should one do the upgrades manually?

THanks

Re: Important: Activiti 5.15 and MySQL 5.6+ users

jbarrez — Mon, 15 Sep 2014 12:02:31 GMT

The code does take that in account:

https://github.com/Activiti/Activiti/blob/master/modules/activiti-engine/src/main/java/org/activiti/engine/impl/db/DbSqlSession.java#L1211

It should take the 5.5 sql. But i assume that's not doing it for you? What do you see passing for the logging line at https://github.com/Activiti/Activiti/blob/master/modules/activiti-engine/src/main/java/org/activiti/engine/impl/db/DbSqlSession.java#L1215 ?

Re: Important: Activiti 5.15 and MySQL 5.6+ users

pkonyves — Fri, 26 Sep 2014 19:36:30 GMT

Most probably it works then. I actually did not try the upgrade mechanism, just looked at the code if it should work, and found no evidence, because I was expecting activiti to return with the activiti.mysql55.*.sql files in getResourceForDbOperation method, but now I can see you choose another solution.

Re: Important: Activiti 5.15 and MySQL 5.6+ users

atifraza — Fri, 30 Jan 2015 07:27:09 GMT

I have done the following changes to make explorer multi tenant aware as I needed very much.

1. Extended DefaultLoginHandler java class and injected from activiti-standalone-context.xml and did the following customizations.
1.1) Changed the definition of injection of DefaultLoginHandler in activiti-standalone-context.xml file as below