Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-7537

XWiki and PosgreSQL 3.0

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Blocker
    • None
    • 3.4, 3.3.1
    • None
    • None
    • postgresql-9.0.6-1, postgresql-9.0-802.jdbc4.jar
    • Unknown

    Description

      I'm getting same exception when upgrading from 3.1.1 as described in
      http://jira.xwiki.org/browse/XWIKI-7388

      Adding
      <property name="jdbc.use_streams_for_binary">false</property>
      into hibernate.cfg.xml does not have any effect

      Adding
      <typedef name="materialized_clob" class="org.hibernate.type.StringClobType" />
      into xwiki.hbm.xml helps to display and edit, but xar importing and file attaching dies

      org.hibernate.HibernateException: Failed to commit or rollback transaction. Root cause [ SQL next exception = [org.postgresql.util.PSQLException: ERROR: column "xwa_content" is of type bytea but expression is
      of type bigint
        Rada: You will need to rewrite or cast the expression.
        Pozice: 67]]
              at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:876) ~[xwiki-platform-legacy-oldcore-3.4.jar:na]
              at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:840) ~[xwiki-platform-legacy-oldcore-3.4.jar:na]
              at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:683) ~[xwiki-platform-legacy-oldcore-3.4.jar:na]
              ... 49 common frames omitted
      Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
              at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) ~[hibernate-core-3.6.9.Final.jar
      :3.6.9.Final]
              at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final]
              at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final]
      

      Attachments

        Issue Links

          Activity

            People

              sdumitriu Sergiu Dumitriu
              anthavio Martin Vanek
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: