During the installation of xWiki with an Oracle database, this error appears often :
2021-01-27 11:31:36,824 [XWiki initialization] WARN o.h.e.j.s.SqlExceptionHelper - SQL Error: 904, SQLState: 42000
2021-01-27 11:31:36,825 [XWiki initialization] ERROR o.h.e.j.s.SqlExceptionHelper - ORA-00904: “STRINGPROP1_1_”.“XWP_NAME” : identificateur non valide
This table exists:
SQL> desc XWIKIPROPERTIES;
Name Null? Type
XWP_ID NOT NULL NUMBER(38)
XWP_NAME NOT NULL VARCHAR2(255 CHAR)
XWP_CLASSTYPE VARCHAR2(255 CHAR)
Could this be related to a missing attribute in the hibernate.cfg.xml?
In a previous attempted installation, I got the ORA-00904 error mentioned above. The home page had stacktrace errors with the ORA-00904. However, I noticed also temporary tables with prefix HT_ being created in the database. These were empty, but their counterparts contained data (ex. HT_XWIKIPROPERTIES is empty, but XWIKIPROPERTIES contains data). After consulting the Net, I Added this line:
org.hibernate.hql.spi.id.inline.InlineIdsOrClauseBulkIdStrategy
The temporary tables were not longer present, and the installation finishes. The home page is accessible, however, the application crashes after some navigation. The errors like ORA-00904 are present while initially navigating in the application. But after some simple navigation, the application cashes and the page has stack trace errors with this one among others ORA-00904: “STRINGPROP2_1_”.“XWP_NAME”. I note also that the attribute, xwiki.db=SID in xwiki.cfg points to the correct SID. The attached hibernate.cfg.xml (in text format) has the client specific info absent.
hibernate.cfg.txt (4.4 KB)