topic Re: Update a table in default H2 in Alfresco Archive

Update a table in default H2

shoopi — Mon, 22 Jun 2015 12:42:37 GMT

Hi Guys,I have a process model with very long task descriptions (say around 6k characters). Since the default tables are created with VARCHAR(4000) for these fields I may loose some part of the information therein. Therefore, I'd like to update the default table in a way that it support long text (1

Re: Update a table in default H2

martin_grofcik — Tue, 23 Jun 2015 06:27:27 GMT

Hi Shoopi,

Process definitions are stored in the bytearray blob. String variables (depending on the length) are stored in the VARCHAR(4000) or blob. (see org.activiti.engine.impl.variable.LongStringType). I am not keen on blobs. Do you really need to extend DB schema?

Regards
Martin

Re: Update a table in default H2

shoopi — Tue, 23 Jun 2015 07:19:41 GMT

Hi Martin,

Thank you for your response.
What I really need is to change
<code>
create table ACT_RE_PROCDEF (
    …
    DESCRIPTION_ varchar(4000),
     …
);
</code>
to <code> DESCRIPTION_ varchar(8000) </code>; and
<code>
create table ACT_RU_TASK (
    …
    DESCRIPTION_ varchar(4000),
    …
);
</code>
again to <code>DESCRIPTION_ varchar(8000)</code>
since this field in my processes may contain a very big string with more than 4000 character.

Re: Update a table in default H2

trademak — Wed, 24 Jun 2015 21:13:20 GMT

Hi,

The best way to change is, is just to change your the column type in the database itself.

Best regards,