[jbpm-issues] [JBoss JIRA] Reopened: (JBPM-2017) STRINGVALUE_ column in JBPM_VARIABLEINSTANCE table should be text, not varchar(255)

create table JBPM_MODULEDEFINITION (... NAME_ varchar(255) null, ...)

STRINGVALUE_ column in JBPM_VARIABLEINSTANCE table should be text, not varchar(255) ----------------------------------------------------------------------------------- Key: JBPM-2017 URL: https://jira.jboss.org/jira/browse/JBPM-2017 Project: JBoss jBPM Issue Type: Task Security Level: Public(Everyone can see) Components: Core Engine Affects Versions: jBPM 3.2.4 GA, jBPM 3.2.5 GA Reporter: Alejandro Guizar Assignee: Thomas Diesler Fix For: jBPM-3.2.5.SP1, jBPM 3.2.6 GA In JBPM-1849, Thomas enumerated the current incompatibilites against 3.2.2. One of them is: < create table JBPM_VARIABLEINSTANCE (... STRINGVALUE_ varchar(4000) null, ...) > create table JBPM_VARIABLEINSTANCE (... STRINGVALUE_ varchar(255) null, ...) The new type should be text, not varchar. This is related to the fact that the STRINGVALUE_ column is shared between StringInstance.hbm.xml and HibernateStringInstance.hbm.xml, both in modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/. HibernateStringinstance.hbm.xml does not specify type="text".