0 Replies Latest reply on Feb 25, 2009 9:08 PM by John Gerevich

    Migrating data

    John Gerevich Newbie

      I 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)
      ....