db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: What is default size of Derby Blob filed?
Date Wed, 12 Aug 2009 06:31:11 GMT
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?

> Thanks

View raw message