Migrating data
johnnythehun Feb 25, 2009 9:08 PMI am migrating jbp data tables from mysql5 to oracle9. I am using jboss-portal-2.7.0.CR1.
I have used JBoss Portal to create it's own structure in Oracle.
Then I emptied all oracle tables and populated them with data from mysql.
But if I start JBoss, it wants to insert duplicate path values into jbp_object_node. And because oracle didn't let this it wouldn't start.
So i disabled the unique constraint to see what the portal does.
After this it was able to insert some default tables from it's own default-object.xml, but Hibernate threw an exception I pasted below.
My question is, if I copied the whole table structure and data, why does it still want to update it, even though it worked perfectly when I used mysql?
2009-02-26 03:07:15,375 ERROR [org.jboss.deployment.MainDeployer] Could not start deployment: file:/E:/utils/web/jboss-portal-2.7.0.CR1/server/default/deploy/jboss-portal.sar/conf/data/default-object.xml org.jboss.deployment.DeploymentException: query did not return a unique result: 2; - nested throwable: (org.hibernate.NonUniqueResultException: query did not return a unique result: 2) at org.jboss.portal.core.deployment.jboss.ObjectDeployment.start(ObjectDeployment.java:103) at org.jboss.portal.server.deployment.jboss.DeploymentContext.start(DeploymentContext.java:99) at org.jboss.portal.server.deployment.jboss.PortalDeploymentInfoContext.start(PortalDeploymentInfoContext.java:220) at org.jboss.portal.server.deployment.jboss.ServerDeployer.start(ServerDeployer.java:217) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy211.deploy(Unknown Source) at org.jboss.portal.server.deployment.jboss.ServerDeployer.registerFactory(ServerDeployer.java:119) at org.jboss.portal.server.deployment.jboss.AbstractDeploymentFactory.registerFactory(AbstractDeploymentFactory.java:113) at org.jboss.portal.server.deployment.jboss.AbstractDeploymentFactory.start(AbstractDeploymentFactory.java:152) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.execute(JBossServiceModelMBean.java:486) at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.startService(JBossServiceModelMBean.java:452) ....