hibernate :发现具有给定标识符的多于一行错误-6ren

hibernate :发现具有给定标识符的多于一行错误

转载作者：行者123 更新时间：2023-12-03 10:06:33

我使用的是 spring 4.0.5 和 hibernate 4.3.5；我在使用 hibernate 时遇到错误，我无法弄清楚我错在哪里(因为我确定我错了)。我有一个与自身相关的表，它代表一个网络树，其中每个根节点可以有多个子节点，所以我创建了这个类:

@DynamicUpdate
@Cache(region = "it.eng.angelo.spring.dao.hibernate.models.WebTree", usage = CacheConcurrencyStrategy.READ_WRITE)
@Entity
@Table(name = "MEDIA_GALL_TREE", indexes = {@Index(name = "NOME_FOLDER_IDX", columnList = "NOME_FOLDER")})
public class WebTree extends AbstractModel
{

    private static final long serialVersionUID = -4572195412018767502L;
    private long id;
    private String text;
    private boolean opened;
    private boolean disabled;
    private boolean selected;
    private Set<WebTree> children = new HashSet<WebTree>(0);
    private Set<Media> media = new HashSet<Media>(0);
    private WebTree father;
    private WcmDomain dominio;
    public WebTree()
    {
        super();
    }
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "ID_FOLDER", unique = true, nullable = false)
    public long getId()
    {
        return id;
    }
    public void setId(long id)
    {
        this.id = id;
    }
    @Column(name = "NOME_FOLDER", nullable = false, unique=false)
    public String getText()
    {
        return text;
    }
    public void setText(String text)
    {
        this.text = text;
    }
    @Column(name = "OPENED_FOLDER")
    public boolean isOpened()
    {
        return opened;
    }
    public void setOpened(boolean opened)
    {
        this.opened = opened;
    }
    @Column(name = "DISABLED_FOLDER")
    public boolean isDisabled()
    {
        return disabled;
    }
    public void setDisabled(boolean disabled)
    {
        this.disabled = disabled;
    }
    @Column(name = "SELECTED_FOLDER")
    public boolean isSelected()
    {
        return selected;
    }
    public void setSelected(boolean selected)
    {
        this.selected = selected;
    }
    @OneToMany(mappedBy = "father", orphanRemoval = true, targetEntity = WebTree.class)
    public Set<WebTree> getChildren()
    {
        return children;
    }
    public void setChildren(Set<WebTree> children)
    {
        this.children = children;
    }
    @ManyToOne(targetEntity = WebTree.class)
    @JoinColumn(name = "ID_PADRE", nullable = true)
    public WebTree getFather()
    {
        return father;
    }
    public void setFather(WebTree father)
    {
        this.father = father;
    }
    @OneToOne
    @JoinColumn(name="ID_DOMINIO", nullable=false)
    public WcmDomain getDominio()
    {
        return dominio;
    }
    public void setDominio(WcmDomain dominio)
    {
        this.dominio = dominio;
    }
    @OneToMany( mappedBy = "folder", orphanRemoval = true, targetEntity = Media.class, cascade = { CascadeType.ALL })
    public Set<Media> getMedia()
    {
        return media;
    }
    public void setMedia(Set<Media> media)
    {
        this.media = media;
    }

}

如您所见……这是一个非常简单的 POJO 类；现在我创建了这个单元测试:

@Test
public void testLoadModifyTree()
{
    try
    {
        DetachedCriteria dc = DetachedCriteria.forClass(MediaGalleryTree.class);
        dc.setFetchMode("father", FetchMode.JOIN);
        dc.add(Property.forName("id").eq(4l));
        List<MediaGalleryTree> result = hibSvc.search(dc, IConstants.NO_PAGINATION, IConstants.NO_PAGINATION);
        for (MediaGalleryTree mediaGalleryTree : result)
        {
            logger.info(mediaGalleryTree.getId());
        }
    }
    catch (Exception e)
    {
        logger.error(e.getMessage(), e);
    }
}

好吧，我检查了一下，在数据库中我只有 1 个 ID 为 4 的记录；好吧，当我执行此查询时，出现以下错误:

18:48:43,123 ERROR [WcmHibernateDao] Errore nella ricerca con detached criteria DetachableCriteria(CriteriaImpl(it.eng.comi.spring.dao.hibernate.models.MediaGalleryTree:this[][id=4])); More than one row with the given identifier was found: 2, for class: it.eng.comi.spring.dao.hibernate.models.MediaGalleryTree
org.hibernate.HibernateException: More than one row with the given identifier was found: 2, for class: it.eng.comi.spring.dao.hibernate.models.MediaGalleryTree
    at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:100)
    at org.hibernate.loader.entity.EntityLoader.loadByUniqueKey(EntityLoader.java:161)
    at org.hibernate.persister.entity.AbstractEntityPersister.loadByUniqueKey(AbstractEntityPersister.java:2385)
    at org.hibernate.type.EntityType.loadByUniqueKey(EntityType.java:767)
    at org.hibernate.type.EntityType.resolve(EntityType.java:505)
    at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:170)
    at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:144)
    at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1114)
    at org.hibernate.loader.Loader.processResultSet(Loader.java:972)
    at org.hibernate.loader.Loader.doQuery(Loader.java:920)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
    at org.hibernate.loader.Loader.doList(Loader.java:2553)
    at org.hibernate.loader.Loader.doList(Loader.java:2539)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369)
    at org.hibernate.loader.Loader.list(Loader.java:2364)
    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682)
    at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380)
    at it.eng.comi.spring.dao.WcmHibernateDao.searchEntity(WcmHibernateDao.java:140)
    at it.eng.comi.spring.service.impl.WcmRdbmsExtSvcImpl.search(WcmRdbmsExtSvcImpl.java:237)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
    at com.sun.proxy.$Proxy45.search(Unknown Source)
    at it.eng.comi.test.ComiTests.testLoadModifyTree(ComiTests.java:578)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:74)
    at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:83)
    at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:233)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:87)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
    at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
    at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:176)
    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
18:48:43,135 ERROR [WcmRdbmsExtSvcImpl] Errore nella ricerca con deatchedCriteria DetachableCriteria(CriteriaImpl(it.eng.comi.spring.dao.hibernate.models.MediaGalleryTree:this[][id=4])); Errore nella ricerca con detached criteria DetachableCriteria(CriteriaImpl(it.eng.comi.spring.dao.hibernate.models.MediaGalleryTree:this[][id=4])); More than one row with the given identifier was found: 2, for class: it.eng.comi.spring.dao.hibernate.models.MediaGalleryTree
it.eng.comi.exception.CoMiDbException: Errore nella ricerca con detached criteria DetachableCriteria(CriteriaImpl(it.eng.comi.spring.dao.hibernate.models.MediaGalleryTree:this[][id=4])); More than one row with the given identifier was found: 2, for class: it.eng.comi.spring.dao.hibernate.models.MediaGalleryTree
    at it.eng.comi.spring.dao.WcmHibernateDao.searchEntity(WcmHibernateDao.java:146)
    at it.eng.comi.spring.service.impl.WcmRdbmsExtSvcImpl.search(WcmRdbmsExtSvcImpl.java:237)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
    at com.sun.proxy.$Proxy45.search(Unknown Source)
    at it.eng.comi.test.ComiTests.testLoadModifyTree(ComiTests.java:578)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:74)
    at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:83)
    at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:233)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:87)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
    at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
    at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:176)
    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: org.hibernate.HibernateException: More than one row with the given identifier was found: 2, for class: it.eng.comi.spring.dao.hibernate.models.MediaGalleryTree
    at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:100)
    at org.hibernate.loader.entity.EntityLoader.loadByUniqueKey(EntityLoader.java:161)
    at org.hibernate.persister.entity.AbstractEntityPersister.loadByUniqueKey(AbstractEntityPersister.java:2385)
    at org.hibernate.type.EntityType.loadByUniqueKey(EntityType.java:767)
    at org.hibernate.type.EntityType.resolve(EntityType.java:505)
    at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:170)
    at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:144)
    at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1114)
    at org.hibernate.loader.Loader.processResultSet(Loader.java:972)
    at org.hibernate.loader.Loader.doQuery(Loader.java:920)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
    at org.hibernate.loader.Loader.doList(Loader.java:2553)
    at org.hibernate.loader.Loader.doList(Loader.java:2539)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369)
    at org.hibernate.loader.Loader.list(Loader.java:2364)
    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682)
    at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380)
    at it.eng.comi.spring.dao.WcmHibernateDao.searchEntity(WcmHibernateDao.java:140)
    ... 43 more

执行代码时，hibernate 会打印这些查询:

Hibernate: 
    select
        this_.ID_FOLDER as ID_FOLDE1_7_2_,
        this_.UT_INS as UT_INS2_7_2_,
        this_.DT_INS as DT_INS3_7_2_,
        this_.DT_UPD as DT_UPD4_7_2_,
        this_.UT_UPD as UT_UPD5_7_2_,
        this_.DISABLED_FOLDER as DISABLED6_7_2_,
        this_.ID_DOMINIO as ID_DOMI10_7_2_,
        this_.ID_PADRE as ID_PADR11_7_2_,
        this_.OPENED_FOLDER as OPENED_F7_7_2_,
        this_.SELECTED_FOLDER as SELECTED8_7_2_,
        this_.NOME_FOLDER as NOME_FOL9_7_2_,
        wcmdomain2_.ID_DOMINIO as ID_DOMIN1_8_0_,
        wcmdomain2_.UT_INS as UT_INS2_8_0_,
        wcmdomain2_.DT_INS as DT_INS3_8_0_,
        wcmdomain2_.DT_UPD as DT_UPD4_8_0_,
        wcmdomain2_.UT_UPD as UT_UPD5_8_0_,
        wcmdomain2_.WCM_NOME_DOMINIO as WCM_NOME6_8_0_,
        mediagalle3_.ID_FOLDER as ID_FOLDE1_7_1_,
        mediagalle3_.UT_INS as UT_INS2_7_1_,
        mediagalle3_.DT_INS as DT_INS3_7_1_,
        mediagalle3_.DT_UPD as DT_UPD4_7_1_,
        mediagalle3_.UT_UPD as UT_UPD5_7_1_,
        mediagalle3_.DISABLED_FOLDER as DISABLED6_7_1_,
        mediagalle3_.ID_DOMINIO as ID_DOMI10_7_1_,
        mediagalle3_.ID_PADRE as ID_PADR11_7_1_,
        mediagalle3_.OPENED_FOLDER as OPENED_F7_7_1_,
        mediagalle3_.SELECTED_FOLDER as SELECTED8_7_1_,
        mediagalle3_.NOME_FOLDER as NOME_FOL9_7_1_ 
    from
        MEDIA_GALL_TREE this_ 
    inner join
        WCM_DOMAIN wcmdomain2_ 
            on this_.ID_DOMINIO=wcmdomain2_.ID_DOMINIO 
    left outer join
        MEDIA_GALL_TREE mediagalle3_ 
            on this_.ID_PADRE=mediagalle3_.ID_FOLDER 
    where
        this_.ID_FOLDER=?
Hibernate: 
    select
        mediagalle0_.ID_FOLDER as ID_FOLDE1_7_2_,
        mediagalle0_.UT_INS as UT_INS2_7_2_,
        mediagalle0_.DT_INS as DT_INS3_7_2_,
        mediagalle0_.DT_UPD as DT_UPD4_7_2_,
        mediagalle0_.UT_UPD as UT_UPD5_7_2_,
        mediagalle0_.DISABLED_FOLDER as DISABLED6_7_2_,
        mediagalle0_.ID_DOMINIO as ID_DOMI10_7_2_,
        mediagalle0_.ID_PADRE as ID_PADR11_7_2_,
        mediagalle0_.OPENED_FOLDER as OPENED_F7_7_2_,
        mediagalle0_.SELECTED_FOLDER as SELECTED8_7_2_,
        mediagalle0_.NOME_FOLDER as NOME_FOL9_7_2_,
        wcmdomain1_.ID_DOMINIO as ID_DOMIN1_8_0_,
        wcmdomain1_.UT_INS as UT_INS2_8_0_,
        wcmdomain1_.DT_INS as DT_INS3_8_0_,
        wcmdomain1_.DT_UPD as DT_UPD4_8_0_,
        wcmdomain1_.UT_UPD as UT_UPD5_8_0_,
        wcmdomain1_.WCM_NOME_DOMINIO as WCM_NOME6_8_0_,
        mediagalle2_.ID_FOLDER as ID_FOLDE1_7_1_,
        mediagalle2_.UT_INS as UT_INS2_7_1_,
        mediagalle2_.DT_INS as DT_INS3_7_1_,
        mediagalle2_.DT_UPD as DT_UPD4_7_1_,
        mediagalle2_.UT_UPD as UT_UPD5_7_1_,
        mediagalle2_.DISABLED_FOLDER as DISABLED6_7_1_,
        mediagalle2_.ID_DOMINIO as ID_DOMI10_7_1_,
        mediagalle2_.ID_PADRE as ID_PADR11_7_1_,
        mediagalle2_.OPENED_FOLDER as OPENED_F7_7_1_,
        mediagalle2_.SELECTED_FOLDER as SELECTED8_7_1_,
        mediagalle2_.NOME_FOLDER as NOME_FOL9_7_1_ 
    from
        MEDIA_GALL_TREE mediagalle0_ 
    inner join
        WCM_DOMAIN wcmdomain1_ 
            on mediagalle0_.ID_DOMINIO=wcmdomain1_.ID_DOMINIO 
    left outer join
        MEDIA_GALL_TREE mediagalle2_ 
            on mediagalle0_.ID_PADRE=mediagalle2_.ID_FOLDER 
    where
        mediagalle0_.ID_DOMINIO=?

这些是我的表记录:

id_folder; ut_ins; dt_ins; dt_upd; ut_upd; disabled_folder; opened_folder; selected_folder; nome_folder; id_dominio; id_padre
"1";"system";"2014-06-12 18:23:16.649";"2014-06-12 18:23:16.649";"system";FALSE;FALSE;FALSE;"Root 1";1;
"2";"system";"2014-06-12 18:23:16.662";"2014-06-12 18:23:16.662";"system";FALSE;FALSE;FALSE;"Root 2";2;
"4";"wpsAdmin";"2014-06-13 16:18:01.428";"2014-06-13 18:12:14.228";"wpsAdmin";FALSE;FALSE;FALSE;"Testina";2;2
"7";"wpsAdmin";"2014-06-13 17:33:05.575";"2014-06-13 17:33:10.275";"wpsAdmin";FALSE;FALSE;FALSE;"Angelo";2;2

有人可以告诉我我错在哪里吗？在我看来都是正确的....欢迎任何提示

谢谢
安杰洛

请注意:如果我以这种方式对我的 POJO 类方法 getChildern 进行更改，那么一切都很好:

@OneToMany( mappedBy = "father", targetEntity = WebTree.class, fetch=FetchType.EAGER)
public Set<WebTree> getChildren()
{
    return children;
}

但我想知道为什么会有这种行为？

谢谢
安杰洛

最佳答案

我被 org.hibernate.HibernateException: More than one row with the given identifier was found: 咬了问题，在 StackOverflow 上没有找到任何帮助。解决这个问题花了一段时间，所以我在这里记录了解决方案。我正在使用 JPA/Hibernate 和 Spring Data。

首先，这不是由数据库中的重复行引起的，因为显然不可能有重复的主键。相反，这是由 Hibernate 查找对象并急切地用 LEFT OUTER JOIN 填充一对一关系引起的。 Hibernate 假设单行会返回，但有两行会返回，因为有两个对象与一对一关系相关联。

这是我的对象的简化版本:

@Entity
@Table(name = "plate")
public class Plate {
    private static final long serialVersionUID = 1L;

    @Id
    @SequenceGenerator(name="test_seq", sequenceName="test_seq")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "test_seq")
    @Column(name = "id")
    private Long id;

    @Version
    @Column(name = "object_version")
    private long objectVersion;

    @Column(name = "name")
    private String name;

    @OneToOne(mappedBy = "plate")
    private Sheet sheet;

    public Sheet getSheet() {
        return sheet;
    }

    public void setSheet(Sheet sheet) {
        if (this.sheet != null) {
            this.sheet.setPlate(null);
        }

        this.sheet = sheet;
        sheet.setPlate(this);
    }
}


@Entity
@Table(name = "sheet")
public class Sheet {
    private static final long serialVersionUID = 1L;

    @Id
    @SequenceGenerator(name="test_seq", sequenceName="test_seq")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "test_seq")
    @Column(name = "id")
    private Long id;

    @Version
    @Column(name = "object_version")
    private long objectVersion;

    @Column(name = "sheet_name")
    private String sheetName;

    @OneToOne
    @JoinColumn(name = "plate_id")
    private Plate plate;

    public Plate getPlate() {
        return plate;
    }

    // Do not use. Use Plate.setSheet() instead
    void setPlate(Plate plate) {
        this.plate = plate;
    }
}

问题在于 Plate 和 Sheet 之间的 @OneToOne 关系。我最初不想删除孤立表。在我的代码中，我通过 id 查找了一个 Plate 并添加了一个新的 Sheet。这从原始 Sheet 中删除了 Plate-to-Sheet 关系。当我提交事务时，我假设 JPA 会保存所有修改过的对象(板、原始工作表和新工作表)。

这不是真的! JPA 显然是通过从最初加载的对象 (Plate) 向下遍历层次结构来找到修改的对象，但它忽略了现在孤立的原始 Sheet 被修改的事实。这意味着原始 Sheet 的 sheet.plate_id 列未在数据库中清除。换句话说，我在数据模型中破坏了它们的关系，但它未能保存到数据库中。因此，下次我尝试加载板时，Hibernate 会运行如下查询:

select
    plate1_.id as id1_19_12_, 
    plate1_.object_version as object_v2_19_12_, 
    plate1_.name as name3_19_12_, 
    sheet2_.id as id1_39_12_, 
    sheet2_.object_version as object_v2_39_12_, 
    sheet2_.sheet_name as sheet_nam2_39_12_, 
    sheet2_.plate_id as plate_id4_39_12_, 
from 
    plate plate1_
    left outer join sheet sheet2_ on plate1_.id = sheet2_.plate_id
where 
    plate1_.id=?

这会带回结果集中的 2 行并产生此错误:

org.hibernate.HibernateException: More than one row with the given identifier was found: 10045, for class: com.example.Plate

这是具有欺骗性的:数据库中只有一个具有该 ID 的 Plate 行，但有两个 Sheets 与之链接。

解决方案:
似乎我有两个选择:要么在一对一关系上全部级联并删除孤儿，要么在每次删除与 Plate 的关系时显式调用我的存储库类来查找并保存原始 Sheet。我选择了第一选择并将其添加到板块类中:

@OneToOne(mappedBy = "plate", cascade = CascadeType.ALL, orphanRemoval = true)
private Sheet sheet;

这解决了这个问题。

关于 hibernate :发现具有给定标识符的多于一行错误，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/24210478/

文章推荐： ide - 专业的VHDL IDE？

文章推荐： python - 什么是 "soft keywords"？

蓝牙 UUID 发现
有谁知道蓝牙设备如何获取范围内可发现设备的设备 ID？理想情况下，我正在寻找涉及蓝牙协议(protocol)最小实现的最简单解决方案。一个起点会很好，我只是想创建一个设备，它可以以最小的功耗存储附
rest - 如何通过REST请求更改更改Kibana保存的搜索(发现)？
我有用于搜索Kibana中特定事件的查询，该查询与其他搜索一起保存，是否可以通过REST调用以编程方式更改它？最佳答案正如@Mohammad所说，所有与Kibana相关的元数据都存储在elasti
java - 发现@BootstrapWith的多个声明
我正在使用带有这些注释的基本集成测试: @ExtendWith(SpringExtension::class) @SpringBootTest(classes = [SomeApplication::
jQuery 发现 "selector"
以下是我的代码 HTML: Hello !! Javascript: $(function() { $('#content .child').click(function() {
Rust 发现，配置文件未按预期工作
我试图避免在每个 GDB session 中输入相同的命令。为此，我遵循了 rust discovery book 中的说明。但是当我通过 cargo run 运行程序时，程序没有像书中提到的那样工作
django项目根目录 self 发现
好的，我记得有一些命令可以放在 settings.py 文件中，这样基本上当您将 django 项目移动到另一个目录时，它就不会启动 foo-bar . 我知道我可以通过在它提到主目录的任何地方设置一
javascript - 发现 if 语句中的特定参数不正确？
假设我正在制作一份注册表单。现在我希望它突出显示四个字段中的空白字段。现在我可以只执行一堆 if-else 语句，但这将花费很长时间。假设我有以下代码: Javascript: if($firstn
发现 C++ 正则表达式子字符串错误模式
我试图理解 C++ 中 regex 的逻辑 std::string s ("Ni Ni Ni NI"); std::regex e ("(Ni)"); std::smatch sm; std::re
vim - 发现 Vim 退出状态的原因
运行时: vim /tmp/blah :q echo $? 我的退出状态为 1 .这破坏了包括 Git 在内的各种东西。如果我在没有 vimrc 的情况下运行 vim: vim -u NONE /tm
BASH 发现 ctime 没有按预期工作
我无法通过“查找”来查找旧文件。我将我的发现链接到一个声明中，所有其他部分都运行良好。这是我所拥有的精简版。它搜索 $path 的目录树，并为找到的每个项目创建仅包含换行符的单独临时文件:所有文件、超
c# - 发现 DotNet 无效证书
我已经多次看到这个问题，但没有一个答案对我有用。我的 DotNet Core 应用程序失败编码: public static void Main(string[] args) {
perl - 发现 Perl 内存泄漏
已解决见编辑 2 你好，我一直在编写一个 Perl 程序来处理本地(专有)程序的自动升级(对于我工作的公司)。基本上，它通过 cron 运行，不幸的是有内存泄漏(或类似的东西)。问题是泄漏只发生在
oracle - 发现 Oracle 数据库上的表返回空列表
在 icCube 中创建到 Oracle 数据库的连接时，“选择现有数据库表”返回一个空的表列表。连接很好，我可以查询模式创建 SQL 查询。最佳答案用户用作模式名称，但 Oracle 使用大写
excel - . 发现 VBA 需要很长时间才能跨两个工作表执行
我正在使用 VBA 循环遍历两个工作表上的行，如果它们匹配，则将工作表 2 中的行复制到工作表 1 中。我的代码应该: 打开第二个工作簿将所有信息复制到新工作表上的原始工作簿中然后循环遍历原始工
javascript - 发现 Sequelize 循环依赖
当我尝试同步我的数据库时出现这个奇怪的错误: Unhandled rejection Error: Cyclic dependency found. roles is dependent of its
perl - 发现 Perl 模块所有子例程的最佳方法是什么？
以编程方式发现 perl 模块具有的所有子例程的最佳方法是什么？这可以是一个模块、一个类(没有@EXPORT)或任何介于两者之间的东西。编辑:下面的所有方法看起来都可以工作。我可能会在生产中使用 C
javascript - 发现 meteor 显微镜分享按钮
如何在“讨论”按钮左侧添加“共享”按钮。我希望该按钮与当前的“讨论”按钮具有相同的样式/颜色。我从https://atmospherejs.com/joshowens/shareit添加了包我将
Eclipse 发现 netbeans 没有的语法错误
我最近从 Netbeans 切换到 Eclipse，Eclipse 在我的项目中发现了许多 Netbeans 没有的语法错误，我不知道为什么。据可以看出，两个 IDE 都设置为使用 java 1.6。
javascript - 发现 URL 验证的正确正则表达式存在困难
我必须为我的项目设置一些不接受错误网址的规则。我为此使用正则表达式。我的网址是“http://some/resource/location”。此网址的开头、中间或结尾不应留有空格。例如，这些空格
python - 发现 Azure 虚拟机规模集中的对等实例
问题:鉴于作为 VMSS 的一部分启动的 N 个实例，我希望每个 Azure 实例上的应用程序代码能够发现其他对等实例的 IP 地址。我该怎么做？总体目的是对实例进行集群，以提供主动被动 HA 或保

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

hibernate :发现具有给定标识符的多于一行错误