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

    • Bug
    • Resolution: Fixed
    • Major
    • 3.3, 3.4-milestone-1, 3.2.1
    • 2.7.1, 3.0 M3
    • Storage
    • None
    • Unknown

    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

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

            Dates

              Created:
              Updated:
              Resolved: