[jbpm-issues] [JBoss JIRA] Updated: (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 Fix For: jBPM 4.x In my hibernate config I defined to create the table structure. <hibernate-configuration> <session-factory> <property name="hibernate.connection.driver_class">com.ibm.db2.jcc.DB2Driver</property> <property name="hibernate.dialect">org.hibernate.dialect.DB2Dialect</property> <property name="hibernate.cache.use_second_level_cache">false</property> <property name="hibernate.connection.url">jdbc:db2://localhost:50000/test_db:currentSchema=jBPM;</property> <property name="hibernate.connection.username">db2inst1</property> <property name="hibernate.connection.password">db2inst1</property> <property name="hibernate.hbm2ddl.auto">create-drop</property> <property name="hibernate.format_sql">true</property> <property name="hibernate.show_sql">false</property> <mapping resource="jbpm.repository.hbm.xml" /> <mapping resource="jbpm.execution.hbm.xml" /> <mapping resource="jbpm.history.hbm.xml" /> <mapping resource="jbpm.task.hbm.xml" /> <mapping resource="jbpm.identity.hbm.xml" /> </session-factory> </hibernate-configuration> My process.jpdl.xml: <?xml version="1.0" encoding="UTF-8"?> <process name="helloworld" xmlns="http://jbpm.org/4.4/jpdl"> <start name="start"> <transition name="to request" to="request"/> </start> <end name="end"/> <java class="be.fgov.minfin.ccff.isagategw.isagatefw.Println" method="request" name="request"> <transition name="to review" to="review"/> </java> <task assignee="alex" name="review"> <transition name="approved" to="audit"/> </task> <state name="audit"> <transition name="to end" to="end"/> </state> </process> At last I created a test file ProcessTest: public class ProcessTest extends JbpmTestCase { String deploymentId; public void setUp() throws Exception { super.setUp(); deploymentId = repositoryService.createDeployment() .addResourceFromClasspath("process.jpdl.xml") .deploy(); } public void testProcess() throws Exception { .... } public void tearDown() throws Exception { repositoryService.deleteDeploymentCascade(deploymentId); super.tearDown(); } } In the setUp method when deploying the JPDL the database structure is created. 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.