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: property name=connection.urljdbc:mysql://localhost/xwiki?useServerPrepStmts=false/property property name=connection.usernamexwiki/property property name=connection.passwordxwiki/property 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
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
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 ?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 3/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 12/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
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