AnsweredAssumed Answered

Modifying TEXT2_ column type in ACT_RU_VARIABLE

Question asked by jogahe on Sep 14, 2016
Latest reply on Sep 15, 2016 by jogahe
Hi!

First of all, thanks for your attention.

We have an enterprise app that uses Activiti in its version 5.16.1. Actually, we have some problems with this database table:

create table ACT_RU_VARIABLE (
    ID_ NVARCHAR2(64) not null,
    REV_ INTEGER,
    TYPE_ NVARCHAR2(255) not null,
    NAME_ NVARCHAR2(255) not null,
    EXECUTION_ID_ NVARCHAR2(64),
    PROC_INST_ID_ NVARCHAR2(64),
    TASK_ID_ NVARCHAR2(64),
    BYTEARRAY_ID_ NVARCHAR2(64),
    DOUBLE_ NUMBER(*,10),
    LONG_ NUMBER(19,0),
    TEXT_ NVARCHAR2(2000),
    TEXT2_ NVARCHAR2(2000),
    primary key (ID_)
);

In some cases, we try to save objects as JSON strings that are too big and overflow the columns TEXT_ and TEXT2_. Changing them to NVARCHAR2(4000) is not fixing the problem, as in some cases the objects are even bigger.

We tried and changed the datatype of the column TEXT_ to CLOB, causing Activiti to stop working. But if we do the same change to the column TEXT2_ all seems to work perfectly.

My question is … Are we breaking the Activiti engine by doing this? Or can be an acceptable fix?.

Regards.

Outcomes