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) | .... | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4213217#4213217 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4213217 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
