nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Length of custom property d:text

richardgunderse

Hi

I have a custom property defined as d:text.

I am trying to store a huge value in it (100,000 chars) but I'm getting a Hibernate exception saying it's too long.

Is there a max length for d:text, and can it be dropped altogether? Having no max length constraint at all would be the best for me, as the value is of variable length.

Or, is there a better datatype for this kind of value that I could use, other than d:text?

Thanks

Find more posts tagged with

Comments

jpfi

Hi,
I don't know the max length of d:text, probably this depends on your DBMS…any Hibernate Guru available?
But I would store 100.000 chars in an txt file as an d:content attribute.
Cheers, Jan

richardgunderse

Thanks for the reply Jan - much appreciated

I'll give it a try and post back my results (will be later this evening)

-Richard

richardgunderse

Hi again

Still having problems I'm afraid. I defined my properties as d:content as shown below

            <property name="ix:DocImageBase64">
               <type>d:content</type>
               <mandatory>false</mandatory>
            </property>               
            <property name="ix:DocImage">
               <type>d:content</type>
               <mandatory>false</mandatory>
            </property>‍‍‍‍‍‍‍‍

Both properties have problems though, when the value is huge (over 100,000 chars).
I tried this with a fresh installation and a clean MySQL database (HSQL doesn't seem to have the same problem).

This is the exception reported by Alfresco (after upping the Hibernate logging)

00:24:00,849 ERROR [hibernate.util.JDBCExceptionReporter] Data truncation: Data truncated for column 'serializable_value' at row 1
00:24:00,849 ERROR [event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.DataException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)‍‍‍‍‍‍‍

Does Alfresco support arbitrary-length data types? Any help would be great!

Thanks

richardgunderse

Anyone, please?

archana_bonkanp

how to implement drop down list with static values