Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Inserting BLOB from Java Application

 
Zulfikar Dharmawan
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic