Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.7.1, 3.0 M3
-
Fix Version/s: 3.3, 3.4-milestone-1, 3.2.1
-
Component/s: Storage
-
Labels:None
-
Difficulty:Unknown
-
Similar issues:
Description
XWIKI-5976 introduced escaping of the schema name for all DBs.
However this is causing an issue on Oracle (that we're just noticing now):
- Oracle converts user names in uppercase when no quotes is used. For example: "create user xwiki identified by xwiki;" creates a user named XWIKI (uppercase)
- In Hibernate.cfg.xml we just specify: <property name="connection.username">xwiki</property> and Hibernate seems to be passing this username as is to Oracle which converts it to uppercase. I couldn't find a way to tell Hibernate to escape the passed user, see https://hibernate.onjira.com/browse/HHH-6888
Since we escape the user in XWikiHibernateBaseStore.escapeSchema() Oracle fails with "ORA-01435: user does not exist"