*
The moose likes JDBC and the fly likes Inserting BLOB from Java Application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Inserting BLOB from Java Application" Watch "Inserting BLOB from Java Application" New topic
Author

Inserting BLOB from Java Application

Zulfikar Dharmawan
Ranch Hand

Joined: Feb 01, 2002
Posts: 74
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 ]

Zulfikar Dharmawan
SCJP1.4, ICS DB2, ICD Websphere
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Inserting BLOB from Java Application