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
- is caused by
-
REPLICAT-152 Make sure to not use anything that could become a keywork as column name
- Closed