topic Re: Tables missing for component(s) engine, history, identity in Alfresco Archive

Tables missing for component(s) engine, history, identity

rolf — Tue, 17 Dec 2013 11:14:36 GMT

Hello!I'm new to activiti and need some help…I want to integrate activiti into an existing oracle 11 database.I've created a new schema "activiti" with all the tables.I must log on to the databse with a specific user e.g. "SUPPORT_USER".I use this configuration:setDatabaseSchemaUpdate(false);setData

Re: Tables missing for component(s) engine, history, identity

frederikherema1 — Wed, 18 Dec 2013 08:04:45 GMT

If you set the flag to "false", the minimal checking will be performed (table exists and right version). To circumvent this (eg. you use a manual process to create/update tables), you can set it to ANY value different from "true", "false", "create", …

Eg. if you use the setDatabaseSchemaUpdate("none"), nothing will be done. This is offcourse, an undocumented feature, as it's always safer to have it set to false, to ensure engine boots on a correct engine version. Offcourse, if this doensn't work as expected in the targeted database, this is a good workaround.

Re: Tables missing for component(s) engine, history, identity

rolf — Wed, 18 Dec 2013 09:14:14 GMT

We check the database after running the update scripts. So we do not need to check each time the engine starts.

Thanks for your help!

Re: Tables missing for component(s) engine, history, identity

frederikherema1 — Wed, 18 Dec 2013 10:43:55 GMT

Okay, so setting that property is perfectly fine for your usecase.