Online Workshops
Seize the deal!
Caching Best Practices
2.5 hours
High-Performance SQL
4 hours
High-Performance SQL
12 hours
Read-write and read-only transaction routing with Spring
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 explain how you can implement a read-write and read-only transaction routing mechanism using the Spring framework.
This requirement is very useful since the Single-Primary Database Replication architecture not only provides fault-tolerance and better availability, but it allows us to scale read operations by adding more replica nodes.
JPA and Hibernate Query setParameter – User 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, I’m going to show you how the JPA Query setParameter method works for basic entity attributes, and how you can use it when dealing with custom Hibernate types.
If you ever stumbled on the “column is of type jsonb but expression is of type bytea” PostgreSQL issue and didn’t know how to fix it, then you should definitely read this article.
How to get the SQL query from JPQL or JPA Criteria
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 you can get the auto-generated SQL query from a JPQL or JPA Criteria API entity query.
Single-Primary Database Replication
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 explain what Single-Primary Database Replication is, and how you can use it to increase both application availability and scale read-only transactions.
How to generate JPA entity identifier values using a database sequence
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 you can generate entity identifier values using a database sequence when using JPA and Hibernate.
Using a database sequence is the most efficient Hibernate identifier generation strategy, as it allows you to take advantage of the automatic JDBC batching mechanism.
How to fetch a one-to-many DTO projection 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, I’m going to show you how you can fetch a one-to-many relationship as a DTO projection when using JPA and Hibernate.
While entities make it very easy to fetch additional relationships, when it comes to DTO projections, you need to use a ResultTransformer to achieve this goal.
ManyToOne JPA and Hibernate association best practices
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 what is the best way to map a ManyToOne association when using JPA and Hibernate.
Since the @ManyToOne association is the most common relationship, knowing how to map it properly will have a significant impact on application performance.
A one-to-many is the most common relationship in database tables@vlad_mihalcea explains the best way to map ManyToOne associations when using JPA and Hibernatehttps://t.co/M1U9fwdTdo pic.twitter.com/sQ4yt8aMQ7
— SQL Daily (@sqldaily) May 14, 2020
