I think somehow my Group and User rights for Spaces are corrupted. Is there
some way to verify a problem in the hibernate tables? I was running Xwiki
on a Oracle 9 database which I didn't realize was not supported until
reading through the Xwiki Dev maillist. I had many exceptions about clob
mapping in the xwiki log even after upgrading to Oracle 10 jdbc driver which
should have fixed it. I tried to delete and re-add the Groups but when I
re-added the Groups they seemed to already have the rights to the Spaces
they had before I deleted them. It seems like the delete Group failed.
I want to export xwiki data from Oracle 9 and import it into a new Oracle 10
database. The import would allow me to select specific items to import.
So, I tried to use the export Admin function which can successfully export
everything but then the import function cannot read anything very large.
Even if you increase the maximum upload size , and increase heap size you
will still run out of memory on import (my export data was about 45MB). I
found jira bugs and mail posts related to this problem. I also encountered:
XWIKI-1809 during import.
I can use Oracle tools to extract and reload the data but it will reload the
same corrupt data that I was trying to fix.
I found the xwiki-packager-plugin but it seems to have the same issues as
import / export Admin function and seems to be limited to hypersonic db. At
least there is a method called shutdownHSQLDB and a comment about needing to
figure something out for other databases.
Is there some way to validate and fix Xwiki Group / User rights before I
extract using oracle? Is there some way to extract a portion of the data
stored in the hibernate managed tables? I would like to extract data for
each space without any users and groups. I could help on the import /
export if it can be fixed but I'm not sure requiring all xwiki data in
memory at once can be fixed. Has another approach been discussed?
Any suggestions on any of the above issues are welcome. I'd really like to
use Xwiki!
Thanks
Glenn Everitt
--
View this message in context:
http://www.nabble.com/Import---Export-Options---Problems-with-rights-tp1657…
Sent from the XWiki- Dev mailing list archive at
Nabble.com.