On Tue, Mar 25, 2008 at 9:36 AM, Kamna Jain <[email protected]> wrote:

Hello,

We have setup XWiki WAR with Tomcat 6.0.16 and oracle (express 10g) (JDK 1.5.0_15) While setting up the DB, these are the settings for username and pwd -

<property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property>

Does this mean that only"xwiki" should be used as username and pwd.

We got the following Tomcat error when we tried to change these settings from xwiki to something else.

2008-03-20 16:34:33,185 http://localhost/xwiki_v1.3/bin/view/Main/WebHome http-80-1 ERROR store.XWikiHibernateBaseStore - Failed updating schema while executing query "create table xwiki.feeds_aggregatorgroup (agg_id number(10,0) not null, agg_name clob, primary key (agg_id))" java.sql.SQLException: ORA-01918: user 'XWIKI' does not exist 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) <http://lists.xwiki.org/mailman/listinfo/devs>

You can change the user and password, but you have to create and set the password in your database, too. ORA-01918: user 'XWIKI' does not exist It seems you are still using the user "XWIKI" but this user does not exist on your Oracle db... CREATE USER user_name IDENTIFIED BY password;