Paweł Limanówka [
http://community.jboss.org/people/plimanowka] replied to the discussion
"JBPM 4.1 Blob issue on AS400 DB2"
To view the discussion, visit:
http://community.jboss.org/message/559012#559012
--------------------------------------------------------------
Another workaround for DB2 v9.7 and UDB type 4 driver is to add property file named
DB2JccConfiguration.properties somewhere to the application CLASSPATH with following
content:
db2.jcc.override.progressiveStreaming=2
db2.jcc.override.fullyMaterializeLobData=true
First line forces DB2 UDB driver to turn off "progressive streaming" feature.
Second one instructs the driver to load all LOB data during FETCH (this is ignored unless
progressive streaming is turned off).
Clues leading to this workaround:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com...
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com...
https://jira.jboss.org/browse/JBPAPP-2613 https://jira.jboss.org/browse/JBPAPP-2613
More about UDB type 4 properties:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.i...
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.i....
Anyways, those 2 lines saved my day.
--------------------------------------------------------------
Reply to this message by going to Community
[
http://community.jboss.org/message/559012#559012]
Start a new discussion in jBPM at Community
[
http://community.jboss.org/choose-container!input.jspa?contentType=1&...]