High-Performance Java Persistence Newsletter, Issue 66
Are you struggling with performance issues in your Spring, Jakarta EE, or Java EE application?
What if there were a tool that could automatically detect what caused performance issues in your JPA and Hibernate data access layer?
Wouldn’t it be awesome to have such a tool to watch your application and prevent performance issues during development, long before they affect production systems?
Well, Hypersistence Optimizer is that tool! And it works with Spring Boot, Spring Framework, Jakarta EE, Java EE, Quarkus, Micronaut, or Play Framework.
So, rather than fixing performance issues in your production system on a Saturday night, you are better off using Hypersistence Optimizer to help you prevent those issues so that you can spend your time on the things that you love!
Introduction
Welcome to a new issue of the High-Performance Java Persistence Newsletter in which we share articles, videos, workshops, and StackOverflow answers that are very relevant to any developer who interacts with a database system using Java.
Articles
The pick of this week is this article about the difference between the ON CONFLICT clause and the MERGE statement when using PostgreSQL.
Hibernate 6.6 implements the Jakarta Data specifications, and if you’re curious about how it works, then check out this article I wrote.
Another article worth reading is this one about the advantage of configuring an external replica for a cloud database environment.
If you’re using Spring Boot and want to expose certain metrics, then you can use a custom actuator. For more details about this topic, check out this article.
Public training
From the 21st to the 22nd of October, I’ll be in Oslo to run a new edition of my High-Performance Spring Persistence training.
If you are using Spring and want to get the best out of Spring Data JPA, then you should definitely join this training organized by Bouvet:
Project Releases
PostgreSQL released the 16.4 version, which provides some bug fixes for the 16.3 version.
The PostgreSQL JDBC Driver also released the 42.7.4 version, bringing both bug fixes and performance improvements.
The 12.8.1 version of the SQL Server JDBC Driver was also released. There’s a performance improvement related to reusing prepared statements that’s definitely worth testing.
Hibernate ORM released the 6.6 version that brings support for Jakarta Data, as well as improvements to the array column type mapping, more string-based functions in JPQL, and inheritance for Embeddable types.
Get in touch with my latest articles!
StackOverflow Answers
The following StackOverflow answers have been trending since the last newsletter episode:
- When should we run Analyze table statement in MySQL
- How to map a 2-d matrix in Java with JPA and Hibernate?
- Hibernate
@OneToOnemapping in the reverse direction? - How to choose the id generation strategy when using JPA and Hibernate
- Why do I need Transaction in Hibernate for read-only operations?
