Uploaded image for project: 'Replication'
  1. Replication
  2. REPLICAT-161

Impossible to create the documents table on Oracle

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 1.12.3
    • 1.12.1
    • Entity
    • None
    • Unknown

    Description

      Getting the following error:

      2023-06-29 11:11:38,720 [XWiki initialization] ERROR c.x.x.i.s.h.HibernateStore     - Error executing DDL "create table XWIKI.replication_document (XWD_ID number(19,0) not null, XWRD_OWNER varchar2(768 char) not null, XWRD_CONFLICT number(1,0) default false not null, XWRD_READONLY number(1,0) default false not null, primary key (XWD_ID))" via JDBC Statement
      org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table XWIKI.replication_document (XWD_ID number(19,0) not null, XWRD_OWNER varchar2(768 char) not null, XWRD_CONFLICT number(1,0) default false not null, XWRD_READONLY number(1,0) default false not null, primary key (XWD_ID))" via JDBC Statement
      	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
      	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:581)
      	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:526)
      	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:293)
      	at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:74)
      	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:220)
      	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:123)
      	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:94)
      	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:63)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1171)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1038)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1205)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:264)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.hibernateShemaUpdate(HibernateDataMigrationManager.java:208)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:189)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:735)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:657)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:357)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:637)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:614)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:539)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:867)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:576)
      	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1029)
      	at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:399)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2194)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2256)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1459)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1426)
      	at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1335)
      	at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1272)
      	at com.xpn.xwiki.XWiki.<init>(XWiki.java:1245)
      	at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:103)
      	at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:246)
      	at org.xwiki.job.AbstractJob.run(AbstractJob.java:223)
      	at java.base/java.lang.Thread.run(Thread.java:829)
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "FALSE": invalid identifier
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:702)
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:608)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1248)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1041)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:443)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:518)
      	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:156)
      	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1085)
      	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1571)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1345)
      	at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2198)
      	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2147)
      	at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:330)
      	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193)
      	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193)
      	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193)
      	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
      	... 35 common frames omitted
      Caused by: oracle.jdbc.OracleDatabaseException: ORA-00904: "FALSE": invalid identifier
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:710)
      	... 51 common frames omitted
      

      Sometimes I wonder why we use Hibernate for...

      Attachments

        Issue Links

          Activity

            People

              gdelhumeau Guillaume Delhumeau
              tmortagne Thomas Mortagne
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: