Hello Nikolaos, thanx for your reply (and also thanx to Jonas Almfeldt)! It's working now! I wasn't sure how to search for... all keywords I tried didn't lead me to your answer! ;-)) ----- Original Nachricht ---- Von: Nikos Georgosopoulos <[email protected]> An: XWiki Users <[email protected]> Datum: 17.08.2009 16:52 Betreff: Re: [xwiki-users] Different versions of xwiki in one tomcat
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, <[email protected]> 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.jav a:1623)
at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588)
at
org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatemen t.java:225)
at
org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatemen t.java:225)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseS tore.java:492)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseS tore.java:308)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseS tore.java:254)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBas eStore.java:563)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore. java:1024)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseSt ore.java:1068)
at
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDB Version(XWikiHibernateMigrationManager.java:
at
com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.<init>(AbstractX WikiMigrationManager.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(RequestProces sor.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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Plantschen oder Grog? Der Arcor-Wetterdienst weiss Bescheid! Wassertemperaturen für den Urlaub jetzt checken: www.arcor.de/rd/wetter_wasser