Oracle migration in gatein3.6

[saumya]

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???

[charlesmoore]

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!