Introduction

The Hibernate Types repository gives you extra types and general purpose utilities that are not supported by the Hibernate ORM core.

The main advantage of this project is that it supports a broad range of Hibernate versions, spanning from Hibernate 4.1 to Hibernate 5.4.

Features

JSON

Oracle

You should use the JsonStringType to map a VARCHAR2 column type storing JSON.

You should use the JsonBlobType to map a BLOB column type storing JSON.

SQL Server

You should use this JsonStringType to map an NVARCHAR column type storing JSON.

PostgreSQL

You should use this JsonBinaryType to map both jsonb and json column types.

MySQL

You should use this JsonStringType to map the json column type.

JSON mapping examples

• How to map a Jackson JsonNode to a JSON column
• Java Object to String or Binary JSON column mapping
• How to map JSON collections using JPA and Hibernate
• Java Collection to String or Binary JSON column mapping
• How to customize the Jackson ObjectMapper used by Hibernate-Types
• How to customize the JSON Serializer used by Hibernate-Types
• How to fix the Hibernate “No Dialect mapping for JDBC type: 1111” issue when mixing JSON types with native SQL queries

PostgreSQL Types (e.g. ARRAY, ENUM, INET)

• PostgreSQL ARRAY mapping
• Java Enum to PostgreSQL Enum Type
• How to map the PostgreSQL Inet type with JPA and Hibernate
• How to map a PostgreSQL HStore entity property with JPA and Hibernate
• How to map a PostgreSQL Enum ARRAY to a JPA entity property using Hibernate
• How to map a PostgreSQL Range column type with JPA and Hibernate
• How to map a PostgreSQL Interval to a Java Duration with Hibernate

Generic Types

• How to map java.time.YearMonth to DATE or INTEGER column
• How to map java.time.Year and java.time.Month with JPA and Hibernate
• Character to nullable CHAR column
• ImmutableType utility to simplify UserType implementations

Utilities

• How to map camelCase properties to snake_case column names with Hibernate

Are you struggling with application performance issues?

Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. No more performance issues, no more having to spend countless hours trying to figure out why your application is barely crawling.

Imagine discovering early during the development cycle that you are using suboptimal mappings and entity relationships or that you are missing performance-related settings.

More, with Hypersistence Optimizer, you can detect all such issues during testing and make sure you don't deploy to production a change that will affect data access layer performance.

Hypersistence Optimizer is the tool you've been long waiting for!

Training

If you are interested in on-site training, I can offer you my High-Performance Java Persistence training which can be adapted to one, two or three days of sessions. For more details, check out my website.

Consulting

If you want me to review your application and provide insight into how you can optimize it to run faster, then check out my consulting page.

High-Performance Java Persistence Video Courses

If you want the fastest way to learn how to speed up a Java database application, then you should definitely enroll in my High-Performance Java Persistence video courses.

High-Performance Java Persistence Book

Or, if you prefer reading books, you are going to love my High-Performance Java Persistence book as well.

Installation

Depending on the Hibernate version you are using, you need to following dependency:

Hibernate 5.4, 5.3 and 5.2

<dependency>
    <groupId>com.vladmihalcea</groupId>
    <artifactId>hibernate-types-52</artifactId>
    <version>2.6.1</version>
</dependency>

Hibernate 5.1 and 5.0

<dependency>
    <groupId>com.vladmihalcea</groupId>
    <artifactId>hibernate-types-5</artifactId>
    <version>2.6.1</version>
</dependency>

Hibernate 4.3

<dependency>
    <groupId>com.vladmihalcea</groupId>
    <artifactId>hibernate-types-43</artifactId>
    <version>2.6.1</version>
</dependency>

Hibernate 4.2 and 4.1

<dependency>
    <groupId>com.vladmihalcea</groupId>
    <artifactId>hibernate-types-4</artifactId>
    <version>2.6.1</version>
</dependency>

Requirements

• Java version supported by the Hibernate ORM version you are using.
• SLF4J
• Jackson Databind

How to quickly start test environment

cd docker
docker-compose up -d

How to quickly access to database logs

docker logs -f mysql-hibernate-types
docker logs -f postgresql-hibernate-types

How to quickly terminate test environment

cd docker
docker-compose down -v