Re: [xwiki-users] name of default database
On Mar 14, 2008, at 3:39 AM, squirrely_wrath wrote: > > > > vmassol wrote: >> >> >> On Jan 10, 2008, at 2:31 PM, rssh wrote: >> >>> >>> 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 ? >> >> We'd love that patch . However it's not an easy patch (you/we'll need >> to test it in lots of different conditions: XE, XEM, different >> databases). >> >> Thanks >> -Vincent >> ___ >> users mailing list >> users@xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users >> >> > > Any news on this? I did just run into this issue... For the record the jira issue is there and not implemented yet: http://jira.xwiki.org/jira/browse/XWIKI-2006 -Vincent ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] name of default database
Hi, have you considered changing WEB-INF/hibernate.cfg.xml? I've changed "xwiki" with "xwiki_dev" in the following lines: jdbc:mysql://localhost/xwiki?useServerPrepStmts=false xwiki xwiki and in the steps from http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL and now I have: http://localhost:8080/xwiki for xwiki scheme http://localhost:9090/xwiki for xwiki_dev scheme running simultaneously. Hope that helps. Marius > > > > vmassol wrote: >> >> >> On Jan 10, 2008, at 2:31 PM, rssh wrote: >> >>> >>> 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 ? >> >> We'd love that patch . However it's not an easy patch (you/we'll need >> to test it in lots of different conditions: XE, XEM, different >> databases). >> >> Thanks >> -Vincent >> ___ >> users mailing list >> users@xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users >> >> > > Any news on this? I did just run into this issue... > -- > View this message in context: > http://www.nabble.com/name-of-default-database-tp14734850p16043053.html > Sent from the XWiki- Users mailing list archive at Nabble.com. > > ___ > 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
Re: [xwiki-users] name of default database
vmassol wrote: > > > On Jan 10, 2008, at 2:31 PM, rssh wrote: > >> >> 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 ? > > We'd love that patch . However it's not an easy patch (you/we'll need > to test it in lots of different conditions: XE, XEM, different > databases). > > Thanks > -Vincent > ___ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > > Any news on this? I did just run into this issue... -- View this message in context: http://www.nabble.com/name-of-default-database-tp14734850p16043053.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] name of default database
On Thu, 10 Jan 2008 14:04:20 -, 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 http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"; > true true false 50 5 3 1 1 20 12 20 jdbc:oracle:thin:@localhost:1521:XE grad grad oracle.jdbc.driver.OracleDriver org.hibernate.dialect.OracleDialect com.xpn.xwiki.store.DBCPConnectionProvider 2 2 true 0 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] name of default database
On Jan 10, 2008, at 2:31 PM, rssh wrote: > > 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 ? We'd love that patch . However it's not an easy patch (you/we'll need to test it in lots of different conditions: XE, XEM, different databases). Thanks -Vincent ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] name of default database
Did you change the Hibernate configuration to point to another database though? To do this, change the file "hibernate.cfg.xml" under "xwiki\WEB-INF". -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
[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