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.
Hi, I'm trying to insert BLOB into DB2 UDB 7.2 in Windows 2000, which I have managed to do that. I use put the file into ByteArrayOutputStream and then using PreparedStatement, i use the setBytes method to put it to database. It worked, but... DB2 UDB has limitation. The default query heap size of it is only 4,3 MB. I can increase it to any number but then again i think that won't be the solution, considering how many memory resource will be wasted just to accomodate large file. So, my question is do you guys know how to insert BLOB piece by piece. More like using getChunck and appendChunk in Visual Basic? Please, help me guys, thanks before... [ March 07, 2003: Message edited by: Zulfikar Dharmawan ]