topic Re: Alter DB Schema via executeCustomSQL in Alfresco Archive

Alter DB Schema via executeCustomSQL

fnoorie — Fri, 31 Oct 2014 03:09:11 GMT

Hi,I am running into the issue where the absolute path where my service gets deployed to is ridiculously long (I cant point it to a different path due to some company infra policy). This is causing issues when creating the tables in h2:### SQL: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_,

Re: Alter DB Schema via executeCustomSQL

jbarrez — Fri, 31 Oct 2014 15:45:12 GMT

If your database user has the rights to execute ALTER, there is no reason why you shouldn't be able to do it.

But im seriously wondering why a deployment name needs to be that long

Re: Alter DB Schema via executeCustomSQL

fnoorie — Mon, 03 Nov 2014 17:10:21 GMT

Thanks Joram but my requirement is a bit different. When activiti-engine starts up it creates this table and inserts the process's absolute path (where it fails because of the long name). So is there a way to alter the table right when the engine starts up? (I can use jdbc to do it but that will be overwritten when the engine starts up)

Re: Alter DB Schema via executeCustomSQL

jbarrez — Wed, 05 Nov 2014 13:14:11 GMT

Hmm, no, there is no hookpoint for that I guess. Maybe ProcessEngineLifecycleListener might be something?