Update a table in default H2

[shoopi]

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) VARCHAR(8000) or (2) BLOB. So the question is what is the best way to apply these changes and where I need to change? 

[martin_grofcik]

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

[shoopi]

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.

[trademak]

Hi,

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

Best regards,