Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Tue, 06 Jun 2006 11:03:29 -0400
From: Farrukh Najmi <Farrukh.Najmi@Sun.COM>
Subject: Re: A truncation error was encountered tryin,g to shrink BLOB
 'XX-RESOLVE-XX' to length 1048576.
In-reply-to: <44858890.6020308@apache.org>
Sender: Farrukh.Najmi@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <44859941.8050208@sun.com>
MIME-version: 1.0
Content-type: multipart/mixed; boundary="Boundary_(ID_LLPmi5MZDSb7ZRXWXIp+gA)"
References: <44856D59.6050506@sun.com> <44858890.6020308@apache.org>
User-Agent: Thunderbird 1.5.0.2 (X11/20060420)

This is a multi-part message in MIME format.

--Boundary_(ID_LLPmi5MZDSb7ZRXWXIp+gA)
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT

Daniel John Debrunner wrote:
> 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.
>
>
>   
Thank you Dan! That sounds like the problem.
BTW I am curious why the 2G is not the default?
Is there a performance / space downside to specifying BLOB(2G) always?

-- 
Regards,
Farrukh


--Boundary_(ID_LLPmi5MZDSb7ZRXWXIp+gA)
Content-type: text/x-vcard; name=farrukh.najmi.vcf; charset=utf-8
Content-transfer-encoding: 7BIT
Content-disposition: attachment; filename=farrukh.najmi.vcf

begin:vcard
fn:Farrukh Najmi
n:Najmi;Farrukh
email;internet:farrukh.najmi@sun.com
tel;work:781-442-9017
url:http://ebxmlrr.sourceforge.net/tmp/farrukhRacePointIcon.jpg
version:2.1
end:vcard


--Boundary_(ID_LLPmi5MZDSb7ZRXWXIp+gA)--