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

xwiki with Oracle does not work with database username other than xwiki

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 1.6 M1
    • 1.1 RC1
    • Storage
    • None
    • Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options
    • database account
    • Low

    Description

      I was not able to run XWiki against Oracle 10g using my default username, I've got error messages starting with following:

      11:39:08,015 ERROR P1-19 http://localhost:38080/xwiki/bin/view/Main/ XWikiHibernateBaseStore:updateSchema:359 - Failed updating schema: ORA-01031: insufficient privileges

      11:39:08,062 WARN P1-19 http://localhost:38080/xwiki/bin/view/Main/ JDBCExceptionReporter:logExceptions:71 - SQL Error: 942, SQLState: 42000
      11:39:08,062 ERROR P1-19 http://localhost:38080/xwiki/bin/view/Main/ JDBCExceptionReporter:logExceptions:72 - ORA-00942: table or view does not exist

      Note I am sure I had sufficient privileges for creating new tables.

      Then I asked our DBA to create another account named "xwiki" and voila - everything worked correctly.

      Attachments

        Issue Links

          Activity

            People

              tmortagne Thomas Mortagne
              koles Pavel Kolesnikov
              Votes:
              3 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: