This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
When I try to insert a large blob (10 megs) into a db2 database using JDBC, I get an error about the query heap not having enough memory. When I increase the query heap size to more than 10 megs, the query executes fine. Interestingly enough, the same blob inserts fine using a CPM. If I guess a number too low, I could wind up with a large blob that crashes at runtime. Is there any way to stream the byte passed so that JDBC doesn't try to load the whole thing in memory at once?