Increasing size of "text" datatype in output parmeter

BPMN & Modeling Discussion & Questions
1

Hi,

I am using http-connector in Camunda Modeller to hit a REST URL and should get a very long response in the output parameter. But I am getting error as below:

### Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Value too long for column “TEXT_ VARCHAR(4000)”

So, what datatype should be used to store such a long response???

Please help

Thanks,
Tushar

1 Like
2

Depends on the database you are using, but since it appears you are using an H2 database you should consider a LOB field type.

The error you are getting suggests you re trying to save the response into a process variable as a text string. If this is the case, try saving it as a binary, it will automatically be saved into the Activiti ACT_GE_BYTEARRAY table.

3

how can we change the data type from “text” in Camunda modeller…
Only 4 options are available:
Type , Script , List , Map…

Thanks,
Tushar

4

Ahh yes, you will need to do this in a service task, you wont be able to get the level of control you need from the Modeler.

5

Hi,
You could consider script such that you can process the result using some script such as groovy etc. In addition, you could then set a process variable yourself and store it as a serialized object or byteArray. By default, strings are stored in the text column with a max size of 4000 characters. ByteArrays are stored as large object types…

regards

Rob

6