[jbpm-issues] [JBoss JIRA] Created: (JBPM-2949) JBPM4_LOB table its field BLOB_VALUE_ is only 255 bytes using database DB2; SQL ERROR 302

JBPM4_LOB table its field BLOB_VALUE_ is only 255 bytes using database DB2; SQL ERROR 302 ----------------------------------------------------------------------------------------- Key: JBPM-2949 URL: https://jira.jboss.org/browse/JBPM-2949 Project: jBPM Issue Type: Bug Security Level: Public (Everyone can see) Affects Versions: jBPM 4.4 Environment: Ubuntu, JBPM 4.4, DB2 9.7, Java 5.0 Reporter: Bastiaan Asselman In my hibernate config I defined to create the table structure. When deploying a jpdl.xml file, the database structure is created. This is done successfully. Unfortunately the length of the BLOB for the column BLOB_VALUE_ of the table JBPM4_LOB is too small, only 255 bytes. My jpdl.xml file is bigger, and can therefor not be stored in the field. This results in the SQL error 302. (the data is too big for the field). If I investigated the jbpm.execution.hbm.xml in the jar jbpm-pvm-4.4.jar, I found that there is no length specified for this field. Strange enough DB2 its default length for a BLOB field is 1MB. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira