hibernate-jsonb

Hibernate 4.3.x (JPA 2.1) + PostgreSQL 9.4 JSONB support example.

• Hibernate dialect with JSONB support
• Hibernate user-type for JSONB support (from a String)
• Static-metamodel & SQL generation
• Simple DAO with native JSONB query

Then test it by running:

$ curl -d "{ \"answer\": 42 }" https://<your-app-name>.herokuapp.com/

For an example that uses Jackson to map POJOs to JSONB see pires/hibernate-postgres-jsonb.

Build and test

PostgreSQL 9.4

Install, configure and start PostgreSQL 9.4 on localhost. If you change this, you must update src/test/resources/META-INF/persistence.xml accordingly.

sudo su postgres
createdb dbtest

Test

mvn clean test

Generate drop-create SQL

The sample app is configured to automatically update the database schema in "prod" mode and (re)create the schema in "test" mode. But you can also manually create the schema with Maven or the scripts in the sql/ directory.

mvn clean package -Pgenerate-sql

See sql/drop-create.sql