Uploaded image for project: '{RETIRED} XWiki Enterprise'
  1. {RETIRED} XWiki Enterprise
  2. XE-1065

XWiki schema cannot be updated in Oracle 11g

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • None
    • 3.2
    • None
    • Windows
      Oracle
    • Oracle, feeds_aggregatorurl

    Description

      Installed 3.2 using the Windows installer - XWiki starts as expected using HSQLDB. Modified hibernate.cfg.xml to use Oracle (Oracle10gDialect), dropped ojdbc14.jar into directory XWIKI_HOME\WEB-INF\lib, modifed xwiki.cfg (xwiki.store.migration=1).

      Starting the wiki generates the following error message:

      2011-12-16 11:37:38,612 http://localhost:8080/xwiki/bin/view/Main/
      ERROR .x.x.s.XWikiHibernateBaseStore - Failed updating schema while executing query [create table xwiki.feeds_aggregatorurl (agg_id number(10,0) not null,
      agg_name long,
      agg_url long,
      agg_date timestamp,
      agg_nb number(10,0),
      primary key (agg_id))]
      java.sql.SQLException: ORA-01754: a table may contain only one column of type LONG

      Attachments

        Issue Links

          Activity

            People

              vmassol Vincent Massol
              stuatomic Stuart Thomas
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: