AnsweredAssumed Answered

Persisting variables that are long Strings throws Exception

Question asked by jmaru on Sep 24, 2012
Latest reply on Jun 3, 2016 by adevore
Hi all,

I am running the Activiti engine against H2 database with history level set to 'full'. When I set a variable with a value which is a large XML string, I get the following exception. First of all, is this just specific to H2 and will it go away if I move to PostGres/Oracle? If not, how can I store a String which has more than 4000 characters using variables in Activiti?

Thanks,
Jeegar


### Cause: org.h2.jdbc.JdbcSQLException: Value too long for column "TEXT_ VARCHAR(4000)": "STRINGDECODE('<Data xmlns=\""http://xml.odc.com/XMLSchema\"">\n  <Request>\n    <DARequestID>1348500422386… (6271)"; SQL statement:
insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_)
    values (
      ?,
      'VariableUpdate',
      ?,

Outcomes