PGJson

postgres json type support for hibernate

License	The Apache Software License, Version 2.0
Categories	JSON Data
GroupId	com.bazarnazar
ArtifactId	pgjson
Last Version	1.3
Release Date	Oct 9, 2014
Type	jar
Description	PGJson postgres json type support for hibernate
Project URL	https://github.com/bazar-nazar/pgjson
Source Code Management	https://github.com/bazar-nazar/pgjson

Download pgjson

Filename	Size
pgjson-1.3.pom
pgjson-1.3.jar	7 KB
pgjson-1.3-sources.jar	3 KB
pgjson-1.3-javadoc.jar	61 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/com.bazarnazar/pgjson/ -->
<dependency>
    <groupId>com.bazarnazar</groupId>
    <artifactId>pgjson</artifactId>
    <version>1.3</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/com.bazarnazar/pgjson/
implementation 'com.bazarnazar:pgjson:1.3'

Gradle Kotlin

// https://jarcasting.com/artifacts/com.bazarnazar/pgjson/
implementation ("com.bazarnazar:pgjson:1.3")

Apache Buildr

'com.bazarnazar:pgjson:jar:1.3'

Apache Ivy

<dependency org="com.bazarnazar" name="pgjson" rev="1.3">
  <artifact name="pgjson" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='com.bazarnazar', module='pgjson', version='1.3')
)

Scala SBT

libraryDependencies += "com.bazarnazar" % "pgjson" % "1.3"

Leiningen

[com.bazarnazar/pgjson "1.3"]

Dependencies

provided (3)

Group / Artifact	Type	Version
org.hibernate : hibernate-core	jar	4.3.0.Final
org.codehaus.jackson : jackson-jaxrs	jar	1.9.13
org.postgresql : postgresql	jar	9.2-1002-jdbc4

Project Modules

There are no modules declared in this project.

PGJson

Hibernate extension for PostgreSQL json type support

This projects provide some classes to simplify work with Postgres json data type in hibernate. It includes extended postgres dialect and objects for type def support. This small library allows to store in json field both HashMap(with any nesting level) and custom objects. Also it supports scheme validation and update

Requirements

Library expects that in your project you have following dependencies

• hibernate core(4.3 or higher)
• jackson (1.9.13) want to add opportunity to support custom converter
• PostgreSQL driver(9.2 or higher)

How to use

• include library into your project

        <dependency>
            <groupId>com.bazarnazar</groupId>
            <artifactId>pgjson</artifactId>
            <version>1.3</version>
        </dependency>

• set com.bazarnazar.pgjson.JsonPostgreSQLDialect as dialect for hibernate
• if you want to store custom object
  • create object that extends com.bazarnazar.pgjson.PGJsonObject
  • add this object as type in @Type to your @Entity and your annotate field or getter for this type where object is stored
• if you want to store collection of objects extend PgJsonCollection and override getReturnedTypeReference() like this

    protected TypeReference getReturnedTypeReference() {
        return new TypeReference<Map<String, SomeType>>() {};
    }

• if you want to store HashMap
  • simply add com.bazarnazar.pgjson.JsonMapType as type in @Type to your @Entity and your annotate field or getter for this type where Hash map is stored

WARNING!!!

• If you have native queries in your project, be sure that you adding entity for this query
• Be careful while editing or passing object for json field. Since it's not immutable changing data directly in this object, can change data in database. It's strongly recommended to create copies

Versions

Version
1.3 Oct 9, 2014
1.2 Sep 16, 2014
1.1 Sep 11, 2014