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 (nike.apache.org: local policy)
MIME-version: 1.0
Content-transfer-encoding: 7BIT
Content-type: text/plain; CHARSET=US-ASCII; format=flowed
Date: Wed, 12 Aug 2009 11:32:17 +0200
From: Kristian Waagan <Kristian.Waagan@Sun.COM>
Subject: Re: What is default size of Derby Blob filed?
In-reply-to: <24931884.post@talk.nabble.com>
Sender: Kristian.Waagan@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <4A828C21.6040607@Sun.COM>
References: <24927200.post@talk.nabble.com> <4A8261AF.1050706@Sun.COM>
 <24931884.post@talk.nabble.com>
User-Agent: Thunderbird 2.0.0.21 (X11/20090623)

sarah.kho wrote:
> Hi,
> Thank you for reply.
> I used    @Column(columnDefinition="blob(6M)") and it is working like a
> horse now.
>   

Glad to hear that :)

I was thinking of using @Column(length=...), but your approach works 
just as well. I'm curious if JPA will use metadata to obtain the maximum 
allowed length, or if it leaves all length-checking to the database itself.

Note that Derby doesn't reserve space for LOBs, so if there is a chance 
your LOBs will be larger than 6M it shouldn't hurt to allow larger objects.
It is currently not possible to change the maximum allowed size of a LOB 
column in Derby, but this feature will be included in the next feature 
release (see DERBY-4256 [1]).


Regards,
-- 
Kristian


[1] https://issues.apache.org/jira/browse/DERBY-4256
> Thanks for the tip.
>
>
> Kristian Waagan-4 wrote:
>   
>> sarah.kho wrote:
>>     
>>> Hi
>>> I am trying to develop an application using JPA and derby.
>>> I have a blob filed (@Lob) in one of my entities. When it creates the
>>> field
>>> in the corresponding table it sets the size of the BLOB filed to 64k, I
>>> am
>>> wondering whether it is a Derby default or it is something related to
>>> JPA.
>>>   
>>>       
>> Hello Sarah,
>>
>> This looks like a value set by JPA to me.
>> In Derby, the maximum allowed length of a Blob is used as the default. 
>> This is 2G-1 (2,147,483,647 bytes).
>>
>> You're not saying which JPA-provider you're using, but does it work to 
>> use the @Column annotation to specify the length of the LOB?
>>
>>
>> Regards,
>> -- 
>> Kristian
>>     
>>> Thanks
>>>   
>>>       
>>
>>     
>
>