db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: A truncation error was encountered tryin,g to shrink BLOB 'XX-RESOLVE-XX' to length 1048576.
Date Tue, 06 Jun 2006 13:52:16 GMT
Farrukh Najmi wrote:

> Dear Derby team,
> I am storing a blob into Derby 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



View raw message