-
1. Re: Data Migration from Hsqldb to Oracle in GateIn
tkyjovsky Oct 13, 2011 8:41 AM (in response to poornima.abhi)Hi Poornima, there is. Gatein Management tool. It's still work in progress but already usable. You can export/import portal layout, pages and navigation. Try using the version 1.0.0.alpha02 which should be usable on GateIn 3.1. The bits are attached to this doc by Nick Scavelli: http://community.jboss.org/wiki/GateIn-ExportImport.
-
2. Re: Data Migration from Hsqldb to Oracle in GateIn
poornima.abhi Oct 14, 2011 10:23 AM (in response to tkyjovsky)Hi Tomas,
Thanks for the quick reply.
I could export data using the command line tool.But was unable to import data using it.
Can u plz help me to fix this.
This is the exception i am getting while importing data
2011-10-14 19:40:22,158 INFO [Importer] Starting import of file epp-exports\portal-objects_2011-10-14_12-28-24.zip for portal container portal
2011-10-14 19:40:22,376 INFO [Importer] Overwrite set to true, overwriting all data.
2011-10-14 19:40:22,689 ERROR [ImportHandler] Exception during import.
java.lang.UnsupportedOperationException
at org.gatein.management.portalobjects.client.impl.ClientDataStorageImpl.create(ClientDataStorageImpl.java:62)
at org.gatein.management.portalobjects.exportimport.impl.ImportHandlerImpl.importPortalConfig(ImportHandlerImpl.java:98)
at org.gatein.management.portalobjects.exportimport.impl.ImportHandlerImpl.importContext(ImportHandlerImpl.java:77)
at org.gatein.management.portalobjects.client.impl.RestfulPortalObjectsMgmtClient.importContext(RestfulPortalObjectsMgmtClient.java:318)
at org.gatein.management.portalobjects.cli.importer.Importer.doImport(Importer.java:164)
at org.gatein.management.portalobjects.cli.importer.ImportMain.main(ImportMain.java:152)
at org.gatein.management.portalobjects.cli.Main.main(Main.java:50)
2011-10-14 19:40:22,720 INFO [ImportHandler] Rolling back any changes that occurred during import.
2011-10-14 19:40:22,720 INFO [ImportHandler] No portal configs were overwritten during import
2011-10-14 19:40:22,720 INFO [ImportHandler] No portal configs were creating during import
2011-10-14 19:40:22,720 INFO [ImportHandler] No pages were overwritten during import
2011-10-14 19:40:22,720 INFO [ImportHandler] No pages were creating during import
2011-10-14 19:40:22,720 INFO [ImportHandler] No navigations were overwritten during import
2011-10-14 19:40:22,720 INFO [ImportHandler] No navigations were creating during import
2011-10-14 19:40:22,720 INFO [Importer] Import was successful.
-
3. Re: Data Migration from Hsqldb to Oracle in GateIn
nscavell Oct 14, 2011 11:42 AM (in response to poornima.abhi)Try using the gadget to import the zip file you exported via command line, or just create the site you are importing through the portal first. I think at some point I didn't allow creating sites through the command line, but allowed it in the gadget.