topic Re: Problem with SQL: Value too long for column when inserting value into ACT_RU_VARIABLE in Alfresco Archive

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

tkarthik26 — Thu, 25 Jun 2015 15:59:03 GMT

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 th

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

mikedias — Thu, 25 Jun 2015 20:49:28 GMT

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.

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

tkarthik26 — Fri, 26 Jun 2015 12:40:29 GMT

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