[xwiki-users] Help: Migration from HSQL to Oracle db
Xwiki friends, We had installed Xwiki with default HSQL and have been using it for a couple of months. We want to migrate to Oracle XE and I am looking for help to understand if there are steps recommended for the migration (data and ui). Any suggestions? Thanks Priti -- View this message in context: http://xwiki.475771.n2.nabble.com/Help-Migration-from-HSQL-to-Oracle-db-tp75... Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi, Priti! As far as I understand, the amount of pages is relatively small, so, the easiest way to migrate is: - export whole wiki as backup package - set up Oracle database - change configuration in hibernate.cfg.xml to use Oracle DB - On detecting empty DB, Distribution Manager will import the default UI pages. - import backup package Should work :-) Вторник, 7 января 2014, 13:24 -08:00 от preethi <[email protected]>:
Xwiki friends,
We had installed Xwiki with default HSQL and have been using it for a couple of months. We want to migrate to Oracle XE and I am looking for help to understand if there are steps recommended for the migration (data and ui). Any suggestions?
Thanks Priti
-- View this message in context: http://xwiki.475771.n2.nabble.com/Help-Migration-from-HSQL-to-Oracle-db-tp75... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Kind regards, Dmitry
Dmitry, I had attempted the exact steps you had listed but faced the below error - 2014-01-07 12:49:23,194 [http://localhost:8080/xwiki/bin/import/XWiki/XWikiPreferences] ERROR c.x.x.p.p.Package - Failed to save document XWiki.XWikiPreferences com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document xwiki:XWiki.XWikiPreferences at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:754) ~[xwiki-platform-legacy-oldcore-5.2.1.jar:na] I assumed I was incorrect in my steps. Do you have any recommendations on how to fix this error during import? -- View this message in context: http://xwiki.475771.n2.nabble.com/Help-Migration-from-HSQL-to-Oracle-db-tp75... Sent from the XWiki- Users mailing list archive at Nabble.com.
Maybe you lost permissions when changed XWikiPreferences page during import. IMHO safer way for full XAR file import is using superadmin account (set in xwiki.cfg file). Valdis
Dmitry, I had attempted the exact steps you had listed but faced the below error -
2014-01-07 12:49:23,194 [http://localhost:8080/xwiki/bin/import/XWiki/XWikiPreferences] ERROR c.x.x.p.p.Package - Failed to save document XWiki.XWikiPreferences com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document xwiki:XWiki.XWikiPreferences at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:754) ~[xwiki-platform-legacy-oldcore-5.2.1.jar:na]
I assumed I was incorrect in my steps. Do you have any recommendations on how to fix this error during import?
-- View this message in context: http://xwiki.475771.n2.nabble.com/Help-Migration-from-HSQL-to-Oracle-db-tp75... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (3)
-
Dmitry Bakbardin -
preethi -
Valdis Vītoliņš