Increase lenght of instance variables

horick — Sat, 26 Jul 2014 00:25:26 GMT

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 de

Re: Increase lenght of instance variables

frederikherema1 — Tue, 29 Jul 2014 08:18:03 GMT

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.

topic Increase lenght of instance variables in Alfresco Archive

Increase lenght of instance variables

Re: Increase lenght of instance variables