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.