Java 25th anniversary
Seize the deal!
Book
Save 6.25$
Video Course
Save 49.75$
Hypersistence Optimizer
Save 12.25$
The best way to use a Hibernate ResultTransformer
Last modified:
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
In this article, I’m going to present the best way to use a Hibernate ResultTransformer so that you can customize the result set of a given JPA or Hibernate query.
As I already explained, the Hibernate ResultTransformer is a very powerful mechanism, allowing you to customize a JPQL, Criteria API, or native SQL query result set in any possible way.
The best way to prevent JPA and Hibernate performance issues
Last modified:
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
In this article, I’m going to present the best way to prevent performance issues when using JPA and Hibernate.
Many years ago, I used to work as a team leader, and, one day, the General Manager asked me to take a look at a project that was in big trouble.
The application in question had been developed by a team of software developers for over 9 months, and the client had just tested in a production-like environment.
The client got very upset when realizing that the application was barely crawling. For instance, I was told that a query had been running for 10 hours without showing any signs of stopping.
After analyzing the project, I identified many areas that could have been improved, and that’s how my passion for high-performance data access was born.
The best way to prevent JPA and Hibernate performance issues.https://t.co/9FDS0NwAPt pic.twitter.com/5tycyhfj6X
— Java (@java) January 7, 2020
How to migrate the hilo Hibernate identifier optimizer to the pooled strategy
Last modified:
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
In this article, I’m going to show you how to migrate from the legacy hilo sequence-based identifier optimizer to the pooled Hibernate strategy.
I decided to write this article after having a discussion with Gerd Aschemann on Twitter about addressing the HHH-13783 Hibernate issue.
How to migrate from the legacy hilo sequence-based identifier optimizer to the pooled Hibernate strategy.https://t.co/axf70HwMU4 pic.twitter.com/rC73MztVoO
— Java (@java) December 20, 2019
SQL CROSS JOIN – A Beginner’s Guide
Last modified:
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
In this article, we are going to see how a CROSS JOIN works, and we will also make use of this SQL join type to build a poker card game.
How does the 2PL (Two-Phase Locking) algorithm work
Last modified:
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
The 2PL (Two-Phase Locking) algorithm is one of the oldest concurrency control mechanisms used by relational database systems to guarantee data integrity.
In this article, I’m going to explain how the 2PL algorithm works and how you can implement it in any programming language.
How does the 2PL (Two-Phase Locking) algorithm work? @vlad_mihalcea explains.https://t.co/J4BtK3qQJn pic.twitter.com/pm12b3tE7t
— Java (@java) December 4, 2019
Bulk update optimistic locking with JPA and Hibernate
Last modified:
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
In this article, we are going to see how we can adjust a bulk update statement so that it takes optimistic locking into consideration.
While Hibernate has been supporting versioned HQL queries for a very long time, it’s actually very easy to achieve this goal even with standard JPQL or JPA Criteria API.
Bulk update optimistic locking with JPA and Hibernate.https://t.co/OsBnhkiHQj pic.twitter.com/BFqe4uL7LS
— Java (@java) December 2, 2019
PostgreSQL trigger consistency check
Last modified:
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
In this article, we are going to see how to implement a non-trivial consistency check using a PostgreSQL INSERT and UPDATE trigger.
By using a database trigger after executing an INSERT or UPDATE, we can ensure that the sum of salaries in a given department does not exceed the maximum budget allocated for the given department.
The best way to fix the Hibernate MultipleBagFetchException
Last modified:
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
If you’ve been using Hibernate for some time, there is a good chance you bumped into a MultipleBagFetchException issue:
org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
In this article, we are going to see the reason Hibernate throws the MultipleBagFetchException as well as the best way to solve this issue.
Spring Boot performance tuning
Last modified:
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
While developing a Spring Boot application is rather easy, tuning the performance of a Spring Boot application is a more challenging task, as, not only it requires you to understand how the Spring framework works behind the scenes, but you have to know what is the best way to use the underlying data access framework, like Hibernate for instance.
In a previous article, I showed you how easily to optimize the performance of the Petclinic demo application. However, by default, the Petclinic Spring Boot application uses the in-memory HSQLDB database, which is not what you’d usually want your application to be optimized for.
In this article, we are going to switch the underlying database from the in-memory HSQLDB to MySQL and run Hypersistence Optimizer to generate a performance tuning report for the JPA and Hibernate data access layer in the context of the MySQL database.
Tuning the performance of a #SpringBoot app can be challenging. @vlad_mihalcea shows you #howto generate a performance tuning report for the #JPA and Hibernate data access layer in the context of the #MySQL database. https://t.co/V2CKQNcg4x pic.twitter.com/5Ii40fGXHo
— Java (@java) November 6, 2019
A beginner’s guide to database deadlock
Last modified:
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
In this article, we are going to see how a deadlock can occur in a relational database system, and how Oracle, SQL Server, PostgreSQL, or MySQL recover from a deadlock situation.