Problem with SQL: Value too long for column when inserting value into ACT_RU_VARIABLE

[tkarthik26]

Hi,

Typically the TEXT_ column in ACT_RU_VARIABLE supports only 4000 bytes. I have a situation where I need to store content of mail as string in this column, which will exceed the varchar2 max bytes. This is throwing SQL exception as "value too long for column".<!–break–>

How to proceed in this situation? Can we split it into two columns i.e TEXT_ and TEXT2_?

[mikedias]

Hi,

After Activiti 5.15 version, this is automatically handled by the LongStringType. It will store the bigger strings in the ACT_GE_BYTEARRAY table.

[tkarthik26]

Thanks, now it is storing as serializable type once I upgraded to activiti 5.17.