10 Jan
2008
10 Jan
'08
2:31 p.m.
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
10 Jan
10 Jan
3:04 p.m.
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: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf
Of rssh
Sent: 10 January 2008 13:32
To: users(a)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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
3:05 p.m.
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
3:20 p.m.
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: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf
Of rssh
Sent: 10 January 2008 13:32
To: users(a)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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Ruslan Shevchenko
GradSoft. http://www.gradsoft.ua
14 Mar
14 Mar
3:39 a.m.
vmassol wrote:
On Jan 10, 2008, at 2:31 PM, rssh wrote:
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.
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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
9:31 a.m.
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:
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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
9:40 a.m.
On Mar 14, 2008, at 3:39 AM, squirrely_wrath wrote:
vmassol wrote:
For the record the jira issue is there and not implemented yet:
http://jira.xwiki.org/jira/browse/XWIKI-2006
-Vincent
On Jan 10, 2008, at 2:31 PM, rssh wrote:
Any news on this? I did just run into this issue...
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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
15 Mar
15 Mar
11:57 a.m.
New subject: [xwiki-users] Fw: Re: name of default database
vmassol wrote:
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 Jan 10, 2008, at 2:31 PM, rssh wrote:
Any news on this? I did just run into this issue...
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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
12:38 p.m.
New subject: [xwiki-users] Fw: Re: name of default database
On Sat, Mar 15, 2008 at 11:57 AM, rssh <rssh(a)gradsoft.com.ua> wrote:
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.
vmassol wrote:
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])
On Jan 10, 2008, at 2:31 PM, rssh wrote:
Any news on this? I did just run into this issue...
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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne
1:32 p.m.
New subject: [xwiki-users] Fw: Re: name of default database
On Sat, 15 Mar 2008 12:38:20 +0100, Thomas Mortagne wrote
--
Ruslan Shevchenko
GradSoft. http://www.gradsoft.ua
On Sat, Mar 15, 2008 at 11:57 AM, rssh
<rssh(a)gradsoft.com.ua> wrote:
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.)
vmassol wrote:
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])
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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Any news on this? I did just run into this issue... >
> 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
6029
days inactive
6094
days old
9 comments
6 participants
participants (6)
-
Esbach, Brandon -
Marius Dumitru Florea -
rssh -
squirrely_wrath -
Thomas Mortagne -
Vincent Massol