15 Jan
2008
15 Jan
'08
11:51 a.m.
On Tue, 15 Jan 2008 11:14:26 +0100, Thomas Mortagne wrote
2008/1/14, rssh <rssh(a)gradsoft.com.ua>ua>:
On Mon, 14 Jan 2008 15:07:11 +0100, Thomas
Mortagne wrote
2008/1/14, rssh <rssh(a)gradsoft.com.ua>ua>:
Or, in such case we have:
scheme-based, non-virtual mode: patch do all work correctly. (ok)
scheme-based, virtual mode: patch do all work correctly. (ok)
database-based, non-virtual mode: path does not touch nothing (ok, I think)
database-based, virtual mode: see below: (problem)
path does not touch nothing for main database, but touch virtual databases,
except case, when we call setDatabase() for main database On Mon, 14 Jan 2008 14:30:30 +0100, Thomas
Mortagne wrote
> No as the goal of this code is not to chose the database/schema where
> to works, it set the schema name to use when generating the update
> script for database engines based on schemas. MySQL does not need it
> because MySQL is based on databases.
>
> The only place where database/schema is really changed is
> setDatabase() and only in non virtual mode as far as I know.
>
May be you mean 'only in virtual mode' ?
Yes sorry setDatabase works only in virtual mode.
I tested your patch (at last) with
"xwiki.db=toto" and
"xwiki.virtual.db.prefix=prefix" and my results are :
- mysql
- virtual : change main wiki database name and correctly apply
prefix (could be usefull)
- non-virtual : do noting (useless)
- hsqldb :
- virtual : change main wiki database name and correctly apply
prefix (could be usefull)
- non-virtual : updateSchipt is done in toto and
retrieve/save
document in PUBLIC (not ok)
- non-virtual : updateSchipt is done in toto and retrieve/save
document in PUBLIC (not ok)
Thanks ! I will try to reproduce results and do something with this.
- postgre :
- non-virtual : do nothing (useless)
- virtual : not implemented
To summarize : this patch does not works with hsqldb and derby and
only work in virtual mode. As I said before "table.setSchema" does
It works for me for oracle in non-virtual mode.
(I actually wrote it (and use now) for oracle in non-virtual mode).
not change default schema it only set schema to use in
update script.