1 Reply Latest reply on Dec 13, 2013 8:09 AM by Charles Moore

    Oracle migration in gatein3.6

    saumya tm Newbie

      Hi

       

      I am migrating from gatein3.2 to 3.6( with jboss7) . i want to import the JCR and IDM tables to my oracle database.

      I have changed standalone.xml   but only the JCR tables got imported. Also there are some exceptions and I couldn't  access my application. is there any solution???

        • 1. Re: Oracle migration in gatein3.6
          Charles Moore Newbie

          Here's what I did.


          Edit the file gatein-3.6.0.final-tomcat7/webapps/portal/WEB-INF/conf/organization/idm-configuration.xml and  change the value of hibernate.hbm2ddl.auto from ‘update’ to ‘create’ (line 46)

           

          Start GateIn.  It will populate the tables.


          Shut down GateIn (this would be a good time to export the JCR and IDM schemas in case you ever have to start fresh).

           

          Again edit the file gatein-3.6.0.final-tomcat7/webapps/portal/WEB-INF/conf/organization/idm-configuration.xml .  This time changing the value of hibernate.hbm2ddl.auto from ‘create’ to ‘none’.  If you don’t do this it will re-create the schema every time the portal launches (or so i am told).


          Restart GateIn.


          Celebrate!