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

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

    XMLWordPrintable

    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: