On Thu, 10 Jan 2008 14:04:20 -0000, Esbach, Brandon wrote > Did you change the Hibernate configuration to point to another database > though?
Yew, of course (hibernate.cfg.xml is attached) error is: 6:18:06,857 [http://127.0.0.1:8800/xwiki-enterprise-web-1.2-rc-3/bin/view/Main/ WebHome] [http-8800-1] ERROR store.XWikiHibernateBaseStore - Failed updating s chema while executing query "create table xwiki.feeds_aggregatorgroup (agg_id nu mber(10,0) not null, agg_name clob, primary key (agg_id))" java.sql.SQLSyntaxErrorException: ORA-01918: user 'XWIKI' does not exist at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja va:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1 12) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :173) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1222) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatem ent.java:1706) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java :1674) > To do this, change the file "hibernate.cfg.xml" under "xwiki\WEB-INF". > (I see XWIkik hardoced in hsql => hmm, where hsql is initialized ?) > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of rssh > Sent: 10 January 2008 13:32 > To: users@xwiki.org > Subject: [xwiki-users] name of default database > > Good day. > > I just download xwiki, and see, that it is not possible to set name > of default database scheme other than 'xwiki'. (Becouse > xwiki.tableName is hardcoded in SQL statements) > > Unfortunately. this means that it is hard to use xwiki as platform > for web application, because usually we have situation 'one application/one > database scheme' and want to use few applications (or few version of > same application) simultaneously. > > Question: if I change this and wull create path for configurable > database scheme name of main xwiki instance, would this patches be > accepted (?) or such using is out of scope of interest for xwiki > community ? > > -- > Ruslan Shevchenko > GradSoft. http://www.gradsoft.ua > > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users -- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua
<?xml version='1.0' encoding='utf-8' ?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd" > <hibernate-configuration> <session-factory> <property name="show_sql" >true</property> <property name="use_outer_join" >true</property> <property name="dbcp.defaultAutoCommit" >false</property> <property name="dbcp.maxActive" >50</property> <property name="dbcp.maxIdle" >5</property> <property name="dbcp.maxWait" >30000</property> <property name="dbcp.whenExhaustedAction" >1</property> <property name="dbcp.ps.whenExhaustedAction" >1</property> <property name="dbcp.ps.maxActive" >20</property> <property name="dbcp.ps.maxWait" >120000</property> <property name="dbcp.ps.maxIdle" >20</property> <property name="connection.url" >jdbc:oracle:thin:@localhost:1521:XE</property> <property name="connection.username" >grad</property> <property name="connection.password" >grad</property> <property name="connection.driver_class" >oracle.jdbc.driver.OracleDriver</property> <property name="dialect" >org.hibernate.dialect.OracleDialect</property> <property name="connection.provider_class" >com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size" >2</property> <property name="statement_cache.size" >2</property> <property name="hibernate.connection.SetBigStringTryClob" >true</property> <property name="hibernate.jdbc.batch_size" >0</property> <mapping resource="xwiki.oracle.hbm.xml" /> <mapping resource="feeds.oracle.hbm.xml" /> </session-factory> </hibernate-configuration>
_______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users