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; _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
