Think twice before using an object mapping library to get your DTOs
I often get asked if I can recommend any object mapping library to map entity objects to DTOs. And you can find several discussions and…
How to map composite column types with Hibernate
When most developers design their table and entity models, they create tables that only use basic column types and map these to basic entity attributes.…
How to use PostgreSQL’s JSONB data type with Hibernate
Most databases offer many proprietary features besides the known SQL standard. One example is PostgreSQL’s JSONB data type which allows you to store JSON documents…
Using Window Functions with Hibernate 5 & 6
SQL is an incredibly powerful query language. It provides sheer endless possibilities to extract and transform information. One example of that is a window function.…
Spring Data JPA – How to create a custom base repository
Most developers create their own repositories by adding their queries to one of Spring Data JPA’s standard base repositories, like the JpaRepository or the CrudRepository. These repositories give…