topic Re: com.mysql.jdbc.MysqlDataTruncation: Data too long for column TEXT at row in Alfresco Archive

com.mysql.jdbc.MysqlDataTruncation: Data too long for column TEXT at row

pushpindersingh — Mon, 18 Aug 2014 00:22:12 GMT

Hi All,We are getting following while saving a json value with varchar size > 65,535 on mysql (version 5.1.x) databasecom.mysql.jdbc.MysqlDataTruncation: Data too long for column TEXT at rowI wonder what is right way to fix this problem.I can think of two way:1. Changing table ACT_RU_VARIABLE col

Re: com.mysql.jdbc.MysqlDataTruncation: Data too long for column TEXT at row

martin_grofcik — Mon, 18 Aug 2014 08:06:34 GMT

Hi,

Which activiti version do you use?
I think since 5.15 there is org.activiti.engine.impl.variable.LongStringType which handles long strings and stores them as Serializable type.
(ACT_GE_BYTEARRAY)
Regards
Martin

Re: com.mysql.jdbc.MysqlDataTruncation: Data too long for column TEXT at row

pushpindersingh — Tue, 19 Aug 2014 00:30:06 GMT

Martin, first thanks for quick response.
We are using 5.15

Need more help to use LongStringType.
Currently to store our json object we created class JsonFormType as
<code>
public class JsonFormType extends AbstractFormType implements Serializable{
private static final long serialVersionUID = 1L;

@Override
public String getName() {
return "json";
}

@Override
public Object convertFormValueToModelValue(String propertyValue) {
return propertyValue;
}

@Override
public String convertModelValueToFormValue(Object modelValue) {
return modelValue != null ? modelValue.toString() : null;
}
}
</code>

and formProperty have type as json as below:
<code>
<activiti:formProperty id="someJasonId" name="Some Json Object" type="json" required="true"></activiti:formProperty>
</code>

Now I wonder where LongStringType will fit?
Am I suppose to change JsonFormType class to return LongStringType in convertFormValueToModelValue or should be replacing json to longString in formProperty as
<code>
<activiti:formProperty id="someJasonId" name="Some Json Object" type="longString" required="true"></activiti:formProperty>
</code>

Thanks in advance any hint or advise.

Re: com.mysql.jdbc.MysqlDataTruncation: Data too long for column TEXT at row

martin_grofcik — Tue, 19 Aug 2014 04:24:28 GMT

Hi,

From my point of view there is no need to create any new type. Your json variable should be recognized automatically as LongStringType (put breakpoint to LongStringType class) and it should be stored as
BYTES_ LONGBLOB,

in mysql.

If it does not help - create jUnit test
http://forums.activiti.org/content/sticky-how-write-unit-test

Regards
Martin