[
http://jira.xwiki.org/jira/browse/XWIKI-1719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_19884
]
Ben Vitale commented on XWIKI-1719:
-----------------------------------
I'm seeing the same thing on an Oracle 9i installation.
15:51:03,725 WARN TP-Processor2 https://localhost/xwiki/bin/view/Main/WebHome
Oracle9Dialect:<init>:37 - The Oracle9Dialect dialect has been deprecated; use
either Oracle9iDialect or Oracle10gDialect instead
15:51:03,725 WARN TP-Processor2 https://localhost/xwiki/bin/view/Main/WebHome
OracleDialect:<init>:26 - The OracleDialect dialect has been deprecated; use
Oracle8iDialect instead
15:51:04,881 WARN TP-Processor2 https://localhost/xwiki/bin/view/Main/WebHome
Oracle9Dialect:<init>:37 - The Oracle9Dialect dialect has been deprecated; use
either Oracle9iDialect or Oracle10gDialect instead
15:51:04,881 WARN TP-Processor2 https://localhost/xwiki/bin/view/Main/WebHome
OracleDialect:<init>:26 - The OracleDialect dialect has been deprecated; use
Oracle8iDialect instead
15:51:05,349 ERROR TP-Processor2 https://localhost/xwiki/bin/view/Main/WebHome
XWikiHibernateBaseStore:updateSchema:362 - Failed updating schema: ORA-01918:
user 'XWIKI' does not exist
If I create an "xwiki" user in the DB and change my hibernate.cfg.xml to point
to that user, everything works fine.
Any updates on this issue?
> xwiki with Oracle does not work with database username other than xwiki
> -----------------------------------------------------------------------
>
> Key: XWIKI-1719
> URL: http://jira.xwiki.org/jira/browse/XWIKI-1719
> Project: XWiki Platform
> Issue Type: Bug
> Components: Storage
> Affects Versions: 1.1 RC1
> Environment: Oracle Database 10g Enterprise Edition Release
> 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining
> options
> Reporter: Pavel Kolesnikov
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.xwiki.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
notifications mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/notifications
