[JBoss JIRA] Created: (JBPM-2949) JBPM4_LOB table its field BLOB_VALUE_ is only 255 bytes using database DB2; SQL ERROR 302
4:50 a.m.
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
5:04 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2949) JBPM4_LOB table its field BLOB_VALUE_ is only 255 bytes using database DB2; SQL ERROR 302
[
https://jira.jboss.org/browse/JBPM-2949?page=com.atlassian.jira.plugin.sy...
]
Bastiaan Asselman updated JBPM-2949:
------------------------------------
Workaround Description:
in the jbpm-pvm-4.4.jar change the jbpm.execution.hbm.xml file.
Specify a length for the BLOB_VALUE_:
<property name="blob" type="blob"><column
name="BLOB_VALUE_" length="40960" /></property>
was:in the jbpm-pvm-4.4.jar change the
Description:
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.
was:
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.
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.
<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.
--
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
4:29 p.m.
New subject: [JBoss JIRA] Updated: (JBPM-2949) JBPM4_LOB table its field BLOB_VALUE_ is only 255 bytes using database DB2; SQL ERROR 302
[
https://jira.jboss.org/browse/JBPM-2949?page=com.atlassian.jira.plugin.sy...
]
Alejandro Guizar updated JBPM-2949:
-----------------------------------
Fix Version/s: jBPM 4.x
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.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5131
days inactive
5200
days old
2 comments
2 participants
participants (2)
-
Alejandro Guizar (JIRA) -
Bastiaan Asselman (JIRA)