topic Re: Execute custom SQL during Activiti DB table creation in Alfresco Archive

Execute custom SQL during Activiti DB table creation

thilo_ginkel — Tue, 19 Jul 2011 10:16:07 GMT

I am looking for a way to add a custom SQL snippet to Activiti's the database schema creation to create a custom index on one of Activiti's tables.Is there a way to accomplish this from the application that embeds Activiti without modifying the Activiti source (e.g., though some hook mechanism)?Than

Re: Execute custom SQL during Activiti DB table creation

jbarrez — Tue, 19 Jul 2011 10:31:00 GMT

No, not without modifying the source.
But if it is only an index, it is easy to just add it after the tables have been created for the first time?

Re: Execute custom SQL during Activiti DB table creation

thilo_ginkel — Tue, 19 Jul 2011 10:38:22 GMT

But if it is only an index, it is easy to just add it after the tables have been created for the first time?

Well, yes, that would be an option with the added difficulty that the application's database scripts run before Activiti is started for the first time, i.e., Activiti's tables will not have been created yet at that point.

Re: Execute custom SQL during Activiti DB table creation

ronald_van_kuij — Tue, 19 Jul 2011 11:05:14 GMT

Then run an additional one after the Activiti tables have been created 😉