I had the same question two days ago. go to xwiki.cfg of the second XWiki installation and FORCE your second user's name as the DB name (there is a line about it).
On Mon, Aug 17, 2009 at 4:08 PM, <michael.co...@arcor.de> wrote: > Hello! > > I want to run different xwiki-versions (currently 1.7.2 and new 1.9.3) on > one host in one tomcat-container (but different folders: webapps/xwiki172 > and webapps/xwiki193) against one Oracle-DB (but different users: xwiki and > xwiki2). > > The user xwiki is used by version 1.7.2 and is running fine, the version > 1.9.3 is configured to use the DB-User xwiki2. > > It seems not to be possible, when I point to http://[...]:8081/xwiki193, I > get: > > 2009-08-17 15:17:46,757 [http://[...]:8081/xwiki193/bin/view/Main/] > [http-8081-Processor23] ERROR store.XWikiHibernateBaseStore > java.sql.SQLException: ORA-00955: name is already used by an existing > object > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) > at > oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) > at > oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1623) > at > oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588) > at > org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) > at > org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:492) > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:308) > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:254) > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:563) > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1024) > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1068) > at > com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java: > at > com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.<init>(AbstractXWikiMigrationManager.java:68) > at > com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.<init>(XWikiHibernateMigrationManager.java:51) > [...] > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown > Source) > at java.lang.Thread.run(Thread.java:619) > 2009-08-17 15:17:46,809 [http://[...]:8081/xwiki193/bin/view/Main/] > [http-8081-Processor23] WARN util.JDBCExceptionReporter > 2009-08-17 15:17:46,809 [http://[...]:8081/xwiki193/bin/view/Main/] > [http-8081-Processor23] ERROR util.JDBCExceptionReporter > > com.xpn.xwiki.XWikiException: Error number 3001 in 3: Cannot load class > com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigra > Wrapped Exception: Error number 0 in 3: Exception while hibernate execute > Wrapped Exception: could not execute query > at com.xpn.xwiki.XWiki.createClassFromConfig(XWiki.java:1005) > at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:728) > at com.xpn.xwiki.XWiki.<init>(XWiki.java:670) > at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:317) > at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:388) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) > at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > at > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > [...] > > It looks a little bit like jira-XWIKI-2009 which is noticed to be fixed. > > Is this possible? How to do? > > hp-ux 11.23 > java 1.6.0.03 > tomcat 5.5.20 > oracle 10.2.0.3 > > > Thanx a lot! > > > Michael > ****** > > > Plantschen oder Grog? Der Arcor-Wetterdienst weiss Bescheid! > Wassertemperaturen für den Urlaub jetzt checken: > www.arcor.de/rd/wetter_wasser > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users