Farrukh Najmi wrote: > > Dear Derby team, > > I am storing a blob into Derby 10.1.2.1 using hibernate and getting this > SQLException from Derby (see second stack trace below). > The blob is just a gig image of size 1.4MB. This seems well within the > 2GB limit for blobs. What is wrong and how can I fix it?
You probably created the table without specifying a length on BLOB, this defaults to BLOB(1M). You need to use BLOB(2G). e.g. create table T (a int, b BLOB(2G)) A bug about this info missing in the doc was reported as DERBY-769 http://issues.apache.org/jira/browse/DERBY-769 Dan.
