休眠@ManyToMany堅持-有解無憂

我有一個關于@ManyToManyrelationShip的問題。

我有一個Category在 DB 中有預定義插入的物體。

我有 Entity Trigger，它必須包含預定義的Category：

@Entity
@Data
public class Category {

    @Id
    private Long id;

    private String name;

    @ManyToMany(cascade = CascadeType.ALL, mappedBy = "categories")
    private Set<Trigger> trigger;

@Entity
@Data
public class Trigger {

    @ManyToMany()
    private Set<Category> categories;
}



Trigger trigger = new Trigger();
trigger.setName(triggerDTO.getName());
trigger.setCategories(triggerDTO.getCategories()
            .stream()
            .map(c -> categoryRepository.findByName(c.getName()))
            .collect(Collectors.toSet()));

因此，當我堅持第一個Trigger一切都很好，但是當我嘗試堅持 next 時Trigger，我看到：

java.lang.StackOverflowError: null
  at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.23.jar:42.2.23]
  at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.23.jar:42.2.23]
  at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114) ~[postgresql-42.2.23.jar:42.2.23]
  at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-4.0.3.jar:na]
  at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar:na]
  at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:390) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:163) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:104) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.loader.collection.plan.AbstractLoadPlanBasedCollectionInitializer.initialize(AbstractLoadPlanBasedCollectionInitializer.java:87) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:710) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:76) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:99) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:2163) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:589) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:264) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:585) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:149) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.collection.internal.PersistentSet.hashCode(PersistentSet.java:458) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at com.myapp.domain.trigger.Trigger.hashCode(Trigger.java:13) ~[classes/:na]
  at java.base/java.util.HashMap.hash(HashMap.java:340) ~[na:na]
  at java.base/java.util.HashMap.put(HashMap.java:612) ~[na:na]
  at java.base/java.util.HashSet.add(HashSet.java:221) ~[na:na]
  at java.base/java.util.AbstractCollection.addAll(AbstractCollection.java:336) ~[na:na]
  at org.hibernate.collection.internal.PersistentSet.endRead(PersistentSet.java:355) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.engine.loading.internal.CollectionLoadContext.endLoadingCollection(CollectionLoadContext.java:239) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.engine.loading.internal.CollectionLoadContext.endLoadingCollections(CollectionLoadContext.java:224) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.engine.loading.internal.CollectionLoadContext.endLoadingCollections(CollectionLoadContext.java:198) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.loader.plan.exec.process.internal.CollectionReferenceInitializerImpl.endLoading(CollectionReferenceInitializerImpl.java:154) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.finishLoadingCollections(AbstractRowReader.java:253) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.finishUp(AbstractRowReader.java:211) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetProcessorImpl.java:96) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:105) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.loader.collection.plan.AbstractLoadPlanBasedCollectionInitializer.initialize(AbstractLoadPlanBasedCollectionInitializer.java:87) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:710) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:76) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:99) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:2163) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:589) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:264) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:585) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:149) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at org.hibernate.collection.internal.PersistentSet.hashCode(PersistentSet.java:458) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
  at com.myapp.domain.trigger.observation.component.Category.hashCode(Category.java:10) ~[classes/:na]
  at java.base/java.util.HashMap.hash(HashMap.java:340) ~[na:na]
  at java.base/java.util.HashMap.put(HashMap.java:612) ~[na:na]
  at java.base/java.util.HashSet.add(HashSet.java:221) ~[na:na]

如果更改設定為串列，作業正常，為什么？

uj5u.com熱心網友回復：

簡而言之：使用

@NoArgsConstructor
@Getter

足以序列化/反序列化而不是您當前的 @Data

它不作業的原因Set是@EqualsAndHashCode在你的@Data。

在這里，每次插入 a 時Trigger，JPA 首先獲取您Trigger及其依賴項Categorys。例如，您有 1Trigger與 1Category

select
    trigger0_.id as id1_1_0_ 
from
    trigger trigger0_ 
where
    trigger0_.id=?

select
    category0_.id as id1_0_0_,
    category0_.name as name2_0_0_ 
from
    category category0_ 
where
    category0_.id=?

因為你把你的Set<Trigger>放在一個Category類中，所以這個Trigger哈希碼將使用 Lombok 計算@EqualsAndHashCode。這就是為什么 JPA 需要加載它Trigger來計算哈希碼

select
    trigger0_.categories_id as categori2_2_0_,
    trigger0_.trigger_id as trigger_1_2_0_,
    trigger1_.id as id1_1_1_ 
from
    trigger_categories trigger0_ 
inner join
    trigger trigger1_ 
        on trigger0_.trigger_id=trigger1_.id 
where
    trigger0_.categories_id=?

所以在你第一次插入時，沒有Trigger，它可以很容易地計算出Category這里完成的事情的哈希碼

insert into trigger(id) values (?)
insert into trigger_categories(trigger_id, categories_id) values (?, ?)

但是在第二次，如果你插入一個newTrigger和previous Category，這一次previousCategory鏈接到了previous Trigger，所以在計算hashCode時，會發生一個回圈

select
    trigger0_.categories_id as categori2_2_0_,
    trigger0_.trigger_id as trigger_1_2_0_,
    trigger1_.id as id1_1_1_ 
from
    trigger_categories trigger0_ 
inner join
    trigger trigger1_ 
        on trigger0_.trigger_id=trigger1_.id 
where
    trigger0_.categories_id=?

select
    categories0_.trigger_id as trigger_1_2_0_,
    categories0_.categories_id as categori2_2_0_,
    category1_.id as id1_0_1_,
    category1_.name as name2_0_1_ 
from
    trigger_categories categories0_ 
inner join
    category category1_ 
        on categories0_.categories_id=category1_.id 
where
    categories0_.trigger_id=?

如果要保留@EqualsAndHashCode，請嘗試忽略關系欄位，例如

@NoArgsConstructor
@Getter
@EqualsAndHashCode(of = {"id"})

或者變成List你說的那樣。

轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/337007.html

標籤：休眠弹簧数据-jpa 弹簧数据

上一篇：SpringBootHibernate創建名稱錯誤的表

下一篇：我想使用@JoinColumns從不同的表中獲取資料-如何創建一個可以傳遞引數的條件？