db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sarah.kho" <sarah....@gmail.com>
Subject Re: What is default size of Derby Blob filed?
Date Wed, 12 Aug 2009 09:15:52 GMT

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

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
>>   
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/What-is-default-size-of-Derby-Blob-filed--tp24927200p24931884.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message