[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
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: [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
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
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: [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua
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 [email protected] 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.
Hi, have you considered changing WEB-INF/hibernate.cfg.xml? I've changed "xwiki" with "xwiki_dev" in the following lines: <property name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</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 [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
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 [email protected] 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
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 [email protected] 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 Need to clarify: patch is ready and need only in testing(from xwiki side, works for me) and committing. (As I see the main reason while it not committed yet -- lack of time of core xwiki committers, and also they just afraid touch low-level stuff [may be with some reason]) Also note, that JIRA support voting, i. e. you can vote for this issue and may be this will help xwiki developers to prioritize this issue to be resolved in non-infinite time frame. -- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua
On Sat, Mar 15, 2008 at 11:57 AM, rssh <[email protected]> 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 [email protected] 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
Need to clarify: patch is ready and need only in testing(from xwiki side, works for me) and committing. (As I see the main reason while it not committed yet -- lack of time of core xwiki committers, and also they just afraid touch low-level stuff [may be with some reason])
The problem was also that this patch add hql queries and almost double them in non virtual mode: for each hibernate transaction it execute a query to force switch to the configured database. But as it's not worst than virtual mode which do exactly the same this to ensure it works on the correct wiki/database.
Also note, that JIRA support voting, i. e. you can vote for this issue and may be this will help xwiki developers to prioritize this issue to be resolved in non-infinite time frame.
-- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
On Sat, 15 Mar 2008 12:38:20 +0100, Thomas Mortagne wrote
On Sat, Mar 15, 2008 at 11:57 AM, rssh <[email protected]> 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 [email protected] 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
Need to clarify: patch is ready and need only in testing(from xwiki side, works for me) and committing. (As I see the main reason while it not committed yet -- lack of time of core xwiki committers, and also they just afraid touch low-level stuff [may be with some reason])
The problem was also that this patch add hql queries and almost double them in non virtual mode: for each hibernate transaction it execute a query to force switch to the configured database. But as it's not worst than virtual mode which do exactly the same this to ensure it works on the correct wiki/database.
Yes. Also note, that you pay this price only if you use this feature. (I thinking about better solution, and can say that this is impossible without changing hibernate code.)
Also note, that JIRA support voting, i. e. you can vote for this issue and may be this will help xwiki developers to prioritize this issue to be
resolved
in non-infinite time frame.
-- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua
participants (6)
-
Esbach, Brandon -
Marius Dumitru Florea -
rssh -
squirrely_wrath -
Thomas Mortagne -
Vincent Massol