Store long strings as variables

[krohm]

Hello,

I am currently trying to store strings of various lengths into JBPM4 context.

This works fine until the string reaches the maximum size defined in the database, then crashes.

The behavior I am trying to obtain is the following :
* String is stored as a String if shorted than the limit.
* String is stored as a Blob if it longer than the limit.

I have tried to remove the following line in the jbpm.variables.types.xml file :

<type name="string" class="java.lang.String" variable-class="org.jbpm.pvm.internal.type.variable.StringVariable" />

This works just fine, as all strings are saved a Blobs as Strings are Serializable . (which is not what I am aiming at).

Is my understanding correct when I assume it is not possible to have my strings handled as Strings or as Blobs depending on their size just with configuration ?

I was thinking of implementing another Variable class in order to replace org.jbpm.pvm.internal.type.variable.StringVariable and handle this. Does it make any sense or is there a much simpler way to do this ?

[shiva0]

I had the same problem persisting persisting objects in xml converted with XMLEncoder

My quick fix for this was to convert it as byte[] before saving the variables. That way it is automatically stored in the LOB table.

[jbarrez]

The problem to make an auto-switch in the engine itself, is that different databases tend to have different max lengths for strings ...