Subject | Re: [firebird-support] Re: GDS Exc... unsuccessful metadata update new record size of 72424 is too big |
---|---|
Author | Michael Weissenbacher |
Post date | 2007-01-31T21:43:07Z |
Hi,
<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
>> Thanks.I've looked into some of my Hibernate mapping files. Things like:
>> 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.
<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