A truncation error was encountered trying to shrink CLOB
to length : org.apache.derby.iapi.services.io.DerbyIOException'.
is thrown from apache ode while trying to do binary data transfer through bpel..
so, seperating the binary transfer from the process can be a workaround..
here is an explanation from ode FAQ (http://ode.apache.org/faq.html):
Q. I'm getting data truncation errors, what does that mean?
A. We try to use sensible sizes for the database columns that contain messages and variables in ODE. However if you're manipulating large quantities of data that may not e enough. The solution in that case is to alter the column that's too short to reserve enough database space for your needs.