persistence@glassfish.java.net

Re: max LOB

From: Prashant Dighe <Prashant.Dighe_at_Sun.COM>
Date: Fri, 20 Jul 2007 13:29:42 -0700

Thanks Marina and Lance.
Please see inline...

Marina Vatkina wrote:
> Resending because the sender was not on the persistence alias at the
> time of the initial email.
>
> -marina
>
> Lance J. Andersen wrote:
>> What database are you using?
SUNWjavadb-core version is 10.2.2.1 (from jes5u1)
>>
>> Some databases have a default size for LOBs/Text/Image and you need
>> to configure your backend accordingly.
Would be great if you can tell me how to do this with derby.
>>
>> Please provide more details WRT Database/version/JDBC Driver and version
org.apache.derby.jdbc.ClientDriver from 10.2.2.1


Thanks,
Prashant
>>
>> Prashant Dighe wrote:
>>
>>> Hello,
>>>
>>> I am sure this must have been answered earlier but I could not
>>> search the archives.
>>>
>>> What is the max size of LOB?
>>> I am using String object and it fails at 64K. I would typically have
>>> strings from 200K to 2M. Can I do this using toplink-essentials?
>>> The toplink version I am using is from AS9.1 IFR.
>>>
>>> Thanks,
>>> Prashant