AnsweredAssumed Answered

Bug in oracle-DDL's

Question asked by hbraun on Oct 6, 2014
Latest reply on Jan 14, 2015 by martin.grofcik
Hi activiti-team,

we had a problem to store string variables with length greater than 2000 chars. An exception  occurs only on oracle databases, with MySQL, H2, etc. it works as expected.
After a while, we found the reason: All DDL define varchars with 4000 chars, only the oracle DDL Scripts create textfields with length 2000.
Most times, it works fine. Only on oracle databases with a string variable with length between 2000 and 4000 you will get an exception. Less than 2000 chars, the string fits in database field, greater then 4000 chars the string is stored as a byte array.

We found the bug in activiti 5.16.1, the DDL in 5.16.3 looks still the same. In our system, we replaced all varchar(2000) with varchar(4000) and it looks fine until now.

Best regards,

Harry Braun

Outcomes