Re: [jboss-user] [jBPM] - JBPM 4.1 Blob issue on AS400 DB2

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&...]