How to improve statement caching efficiency with IN clause parameter padding

Introduction

Recently, I stumbled on the following Twitter thread:

This jOOQ feature is indeed really useful since it reduces the number of SQL statements that have to be generated when varying the IN clause parameters dynamically.

Starting with Hibernate ORM 5.2.18, it’s now possible to use IN clause parameter padding so that you can improve SQL Statement Caching efficiency.

In this article, I’m going to explain how this new mechanism works and why you should definitely consider it when using a relational database system which supports Execution Plan caching.

Continue reading “How to improve statement caching efficiency with IN clause parameter padding”

How to synchronize bidirectional entity associations with JPA and Hibernate

Introduction

While answering this StackOverflow question, I realized that it’s a good idea to summarize how various bidirectional associations should be synchronized when using JPA and Hibernate.

Therefore, in this article, you are going to learn how and also why you should always synchronize both sides of an entity relationship, no matter if it’s @OneToMany, @OneToOne or @ManyToMany.

Continue reading “How to synchronize bidirectional entity associations with JPA and Hibernate”

How to use @PrePersist and @PreUpdate on Embeddable with JPA and Hibernate

Introduction

In a previous article, I explained how you could audit entity modifications using the JPA @EntityListeners for embeddable types.

Since Hibernate ORM 5.2.17 now allows you to use the @PrePersist and @PreUpdate JPA entity listeners, we can simplify the previous example, as you will see in this article.

Continue reading “How to use @PrePersist and @PreUpdate on Embeddable with JPA and Hibernate”