On Tue, Mar 25, 2008 at 9:36 AM, Kamna Jain <kammy.scorpi(a)gmail.com> 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;