topic Re: Architecture while using Activiti Datasource in Alfresco Archive

Architecture while using Activiti Datasource

frankee787 — Tue, 16 Aug 2011 07:25:20 GMT

Dear All, I am trying to convince myself on the architecture of introducing the Activiti Datasource/Database(ADS). When I say ADS, I mean the database where Acitivi store the process states and other process metadata. To be more precise lets take an example. Lets say I have a Loan System as part o

Re: Architecture while using Activiti Datasource

frederikherema1 — Tue, 16 Aug 2011 11:21:53 GMT

All depends on your own preference (and whether or not you should pass by a DBA ), but I don't see a problem in using the same datasource/schema. If you can look at activiti as a "part" of your system, there is really no reason why it shouldn't be there… (the tables are prefixed as well)

Re: Architecture while using Activiti Datasource

mahavirj — Tue, 16 Aug 2011 20:59:04 GMT

having the activiti tables in a different schema but the same db would not require xa transactions

Re: Architecture while using Activiti Datasource

frankee787 — Wed, 17 Aug 2011 04:07:17 GMT

having the activiti tables in a different schema but the same db would not require xa transactions

That would mean …you are referring to Oracle Database. And you are correct. When Acitiviti is in a different schema but same database you WOULD NOT need XA transaction. I believe you could work around the problem with synonyms/grants. Please correct me if I am wrong.

But again that is the speciality of Oracle DB and you are coupled up with it.

Regards,
Franklin

Re: Architecture while using Activiti Datasource

heymjo — Thu, 18 Aug 2011 11:48:21 GMT

Is the transaction not handled on the level of the datasource rather than the underlying resource ? So even if you have 2 datasources pointing to the same database you will still need XA to have atomic use case execution, that's how i thought it worked.

Jorg

PS xa/jta is not a beast anymore, Spring has tamed it quite well

Re: Architecture while using Activiti Datasource

frankee787 — Thu, 18 Aug 2011 11:58:00 GMT

Having two datasources will definitely leave you with no room but to use XA/JTA transactions.

Sure Spring has done a good deal of job to tame XA, nevertheless XA/JTA transactions are still complex and you will see a LOT of problem is production when you have long running processes(I guess)

So do you agree with Single Datasource of Two Datasource(One for the application and One for Activiti ) ?

Re: Architecture while using Activiti Datasource

heymjo — Thu, 18 Aug 2011 12:16:40 GMT

going for the best practice approach and if it were my call I would

- keep the activiti tables separate from the application tables. Keeps the dba happy, some of them like SOC as much as we do ! Also allows to easily upgrade application schema separate from workflow and vice versa.
- use xa, so 2 datasources. This way you're prepared in case you need to access other transactional resources from your use case (e.g. message queues).