PGSQL/hibernate problem while importing DOC document (value too long)

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

PGSQL/hibernate problem while importing DOC document (value too long)

kgardas

Hello,

while trying to import Word document (non trivial) I'm hitting an issue
where underlaying PostgreSQL complains about value too long to be
stored. The message (cut from the console) looks as:

SQL next exception = [org.postgresql.util.PSQLException: ERROR: value
too long for type character varying(200000)]]

Actual exception looks like:

XWD_VERSION='2.1', XWD_CUSTOM_CLASS='', XWD_PARENT='', XWD_CLASS_XML='',
XWD_ELEMENTS='0', XWD_DEFAULT_TEMPLATE='', XWD_VALIDATION_SCRIPT='',
XWD_COMMENT='Created by office importer.', XWD_MINOREDIT='0',
XWD_SYNTAX_ID='xwiki/2.0', XWD_HIDDEN='0' where XWD_ID='-408553786' was
aborted.  Call getNextException to see the cause.
        at
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
~[postgresql-9.0-801.jdbc4.jar:na]
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
~[postgresql-9.0-801.jdbc4.jar:na]
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
~[postgresql-9.0-801.jdbc4.jar:na]
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
~[postgresql-9.0-801.jdbc4.jar:na]
        at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
~[commons-dbcp-1.3.jar:1.3]
        at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
~[commons-dbcp-1.3.jar:1.3]
        at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
~[commons-dbcp-1.3.jar:1.3]
        at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
        at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
        ... 137 common frames omitted

this is XWiki 3.1 enterprise with few our custom patches but they are
not related to the storage nor import functionality, so I guess we've
not broken this ourself.

Do you have any idea how to workaround this issue or even how to
properly fix it?

Thanks a lot!
Karel

_______________________________________________
devs mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/devs