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