Subject Re: [firebird-support] Re: GDS Exc... unsuccessful metadata update new record size of 72424 is too big
Author Michael Weissenbacher
Hi,
>> Thanks.
>> Unfortunatly it's not my design. It's opensource Alfresco CMS that
>> works with DB through Hibernate.
>> I thought about some workaround from Firebird side... Increasing page
>> size or a like... Anyway I'll try to dig into Hibernate mapping files...
> I'm afraid you'll have to do that. The record size limit has nothing
> to do with the page size or anything else that can be changed. The
> internals are full of 16 bit integers. Someday that may change, but
> the change will not be painless or easy.
I've looked into some of my Hibernate mapping files. Things like:
<property name="whatever" type="string" length="5000" />
should be changed to:
<property name="whatever" type="text" />

IMHO it's a bad idea to use VARCHAR columns that large. I can remember
that MSSQL 6.0 (or even 7.0?) limited VARCHAR to 255 characters. I'm
still used to creating TEXT fields for VARCHAR(>255). Maybe you can even
file a bug-report at Alfresco?

Michael