[JBoss JIRA] Created: (JBPM-2369) Allow easy switching between VARCHAR(4000) and TEXT/CLOB
by Alejandro Guizar (JIRA)
Allow easy switching between VARCHAR(4000) and TEXT/CLOB
--------------------------------------------------------
Key: JBPM-2369
URL: https://jira.jboss.org/jira/browse/JBPM-2369
Project: JBoss jBPM
Issue Type: Feature Request
Components: Runtime Engine
Reporter: Alejandro Guizar
Priority: Minor
Fix For: jBPM 3.2.7
DB2 restricts the max row length to be less than the page size, even if the max length is never reached in practice. The "table per class hierarchy" mapping strategy is particularly affected by this restriction, as the combined columns of all subclasses easily add up to an excessive length. In the case of the JBPM_LOG table, the required page size under DB2 is 32KB.
For this reason it is desirable that end users can easily switch from the on-row type VARCHAR to the off-row type TEXT/CLOB. Such a switch would benefit other databases as well, provided it is possible for users to upgrade their existing database schema. One situation where switching would be helpful is JBPM-2057.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 6 months