Increase lenght of instance variables

[horick]

Hi guys,

I want to increase the length for Strings as process variables("ACT_RU_VARIABLE"."TEXT_") in the database! Since in my scenario I save  a string that is longer than 4000 bytes.

I can't modify the engine activiti.*.create.engine.sql, because I only use the activiti-engine.jar in the form of dependency.

Could be possible for I to make them bigger??

Thanks a lot!

[frederikherema1]

That 4000 is not just an random chosen number, it's the least common denominator across all databases (oracle's max is 4000). Since String variables are still query able in our API (using like, equals, not equals, …), strings need to be stored as varchar-types. Blobs are NOT searchable this way. We wanted to keep string-query consistent, hence the error you get.

But since 5.16, we altered this behaviour to write 4000+ strings as a byte-array (as all Serialisables are handled in activiti): https://github.com/Activiti/Activiti/commit/754d6903d64983f2655c0845bdd606a2df0c40d7

Upgrading to 5.16 will allow you to store 4000+ string, without the need for a workaround/wrap as Serializable.