3 Replies Latest reply: Oct 14, 2011 11:42 AM by Nick Scavelli RSS

Data Migration from Hsqldb to Oracle in GateIn

Poornima Abhilash Newbie

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
    Tomas Kyjovsky Newbie

    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 Abhilash Newbie

    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
    Nick Scavelli Novice

    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.