Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-7278

Virtual mode fails on Oracle with "ORA-01435: user does not exist"

    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"

        Attachments

          Activity

            People

            • Assignee:
              vmassol Vincent Massol
              Reporter:
              vmassol Vincent Massol
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: