3 Replies Latest reply on Oct 14, 2011 11:42 AM by nscavell

Data Migration from Hsqldb to Oracle in GateIn

poornima.abhi Oct 13, 2011 6:29 AM

Hi All,

I have a web applcation deployed in GateIn 3.1. I changed the database from hsqldb to Oracle by editing the configuration.properties(GateIn-3.1.0-GA\server\default\conf\gatein\configuration.properties) and tables were generated both in idm and jcr services.

The problem is with data migration.I had added several portlets before changing the database connection to Oracle, and that data resides in hsqldb.How can i migrate those data to Oracle, so that i don't need to start from scratch.Is there any migration tool available or any other mechanism which could transfer data without any loss. Thanks in advance....

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.
Actions
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.
Actions
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.
Actions

Go to original post