Differences

This shows you the differences between two versions of the page.

--- hibernate [2020/12/27 20:35] – external edit 127.0.0.1
+++ hibernate [2023/07/14 12:42] (current) – [Transactional] skipidar
@@ Line 219: / Line 219: @@
+===== Transactional =====
+Seems like when wiring entities, which are affected on both sides - it should happen in 1 transaction.
+In Spring boot you need to annotate a method with ''@Transactional''
+At a high level, Spring creates proxies for all the classes annotated with @Transactional, either on the class or on any of the methods. The proxy allows the framework to inject transactional logic before and after the running method, mainly for starting and committing the transaction.
+https://www.baeldung.com/transaction-configuration-with-jpa-and-spring
+https://thorben-janssen.com/transactions-spring-data-jpa/
+<sxh java>
+@Service
+@Getter
+public class EquipmentService {
+    @Autowired
+    private EquipmentRepository equipmentRepository;
+    @Transactional
+    public void updateEquipmentFeeds(ResourcePK equipmentFeeds, ResourcePK equipmentTarget) {
+        Assert.isTrue(equipmentFeeds.getPartitionId().equals(equipmentTarget.getPartitionId()), "Only allow feeds in same partition");
+        Equipment e1 = equipmentRepository.findById(equipmentFeeds).get();
+        Equipment e2 = equipmentRepository.findById(equipmentTarget).get();
+        e1.getFeeds().add(e2);
+        equipmentRepository.save(e1);
+    }
+}
+</sxh>
+==== ManyToMany with composite key to self ====
+<sxh java>
+    @ManyToMany(fetch = FetchType.EAGER, cascade = CascadeType.ALL)
+    @JoinTable(name="FeedsRel",
+            joinColumns={
+                    @JoinColumn(
+                            name = "feedsrel_child_id",
+                            referencedColumnName = "id"),
+                    @JoinColumn(
+                            name = "feedsrel_child_partitionId",
+                            referencedColumnName = "partitionId")
+            })
+    private Set<Equipment> feeds = new HashSet<Equipment>();
+    // Associations marked as mappedBy must not define database mappings like @JoinTable or @JoinColumn
+    @ManyToMany( cascade = CascadeType.ALL, mappedBy="feeds", fetch = FetchType.EAGER)
+    private Set<Equipment> fedBy = new HashSet<Equipment>();
+</sxh>