topic Re: Is it appropriate to replace the ACT_ID_* Tables with Views of the same names? in Alfresco Archive

Is it appropriate to replace the ACT_ID_* Tables with Views of the same names?

tchu_2000 — Fri, 31 Oct 2014 06:51:43 GMT

The reason why we replace the user/group/membership/info tables with views is that we need to map relevant identity info from our business system into context of the Activiti engine without needless redundancy. Meanwhile, keep the modification to Activiti engine as little as possible so as to benefi

Re: Is it appropriate to replace the ACT_ID_* Tables with Views of the same names?

tchu_2000 — Fri, 31 Oct 2014 07:21:14 GMT

UPDATE:
* I've seen the error occurred is "Activiti database problem: Tables missing for component(s) identity", but I cannot locate which table cannot be properly loaded…
* I've search there is other methods to deal with our use case, such as customizing a SessionFactory. But we are originally .Net developing team (the business system was built in .Net), so we are obliged to know if it's theoretically possible to HACK the problem in an easier way.
* We have no needs to do Create/Update/Delete on identity tables from the Activiti engine.

Re: Is it appropriate to replace the ACT_ID_* Tables with Views of the same names?

jbarrez — Fri, 31 Oct 2014 15:52:49 GMT

Hmmm, i dont think it has been done before … and it will depend on the fact whether your Driver knows it's a view or a table.
But looking at the exception, it doesn't seem like it does

Re: Is it appropriate to replace the ACT_ID_* Tables with Views of the same names?

tchu_2000 — Mon, 03 Nov 2014 03:34:53 GMT

Hi, jbarrez,
Thank you for your prompt reply~ (sorry for timezone gap between our worktime. btw, I really admire your SOHO life )
In fact I've managed to "cheat" activiti-explorer's IdentityService at least on 5.16.3! (using the View mapping scheme)
My database environment: <code>db=mssql jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver</code>

I decide to take a look at why 5.16.4 failed to autowire the IdentityService but I need some help:
Where can I configure <code>processEngineConfiguration.databaseSchemaUpdate</code> and <code>demoDataGenerator.createDemoUsersAndGroups</code> in the 5.16.4?
For 5.16.3, I can config the above properties in WEB-INF\activiti-standalone-context.xml however I failed to find out these flags in 5.16.4..

Wish good mood~

Re: Is it appropriate to replace the ACT_ID_* Tables with Views of the same names?

jbarrez — Mon, 03 Nov 2014 11:07:40 GMT

Yes, we did change from XML -> Java config in the latest release.
And we DO need to update our docs to reflect that…. which we will do soon.

The main idea now is that you make your own kind of config in that case, similar to https://github.com/Activiti/Activiti/tree/master/modules/activiti-webapp-explorer2/src/main/java/org/activiti/explorer/conf.