By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,652 Members | 1,317 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,652 IT Pros & Developers. It's quick & easy.

Help: inserting BLOBs larger than 100k in DB2 8.1

P: n/a
Hi there,

I am using the DB2 universal JDBC driver type 4 to insert BLOBs into a
DB2 database. The Method I used for supplying the BLOB data value is
setBinaryStream(). Everything works fine as long as the binary data is
less than or equal to 100k. Anything larger than that (even for one
byte) will result an exception saying the value is too large.

All the DB2 samples (at least two)I have found have a limit of 100k
(magic number!!!), and I have not found anything involved with data
100k. But as the DB2 doc sates BLOBs in DB2 can be up to 2GB. There

must be some option or trick to get over that magic 100k limit in
inserting BLOBs into DB2.

Could someone please share some tips on resolving this issue? Any help
is greatly appreciated.

Thanks.
Bing.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.