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.comes(a)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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users