AnsweredAssumed Answered

Alter DB Schema via executeCustomSQL

Question asked by fnoorie on Oct 31, 2014
Latest reply on Nov 5, 2014 by jbarrez
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_, DEPLOYMENT_ID_, GENERATED_) values (?, 1, ?, ?, ?, ?)
### Cause: org.h2.jdbc.JdbcSQLException: Value too long for column "NAME_ VARCHAR(255)": "'/***Veryyy long path***/ (306)"; SQL statement:
insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_)

Is there a way to alter db when it starts up via code. Ideally I would like to create/drop db when the service starts/stops (i know how to do this) and alter db right after the service starts.

I tried via executeCustomSQL available on managementService but I guess that doesnt support ALTER.

Appreciate your help.

Outcomes