persistence@glassfish.java.net

Re: max LOB

From: Marina Vatkina <Marina.Vatkina_at_Sun.COM>
Date: Tue, 24 Jul 2007 18:24:21 -0700

That's the default. You can always override it via columnDefinition - see
example in the spec.

Regards,
-marina

Prashant Dighe wrote:
> It appears from this doc that it is appserver's schema generation which
> limits the CLOB size to 64K
> http://docs.sun.com/app/docs/doc/819-3659/6n5s6m599?a=view
>
> Prashant
>
> Prashant Dighe wrote:
>
>> 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