Setting up a table in postgres
CREATE TABLE demoJson(
id SERIAL NOT NULL PRIMARY KEY,
jsonData JSONB NOT NULL
);
Crafting a hibernate entity class named DemoJsonEntity with @TypeDefs
@Entity
@Table(name = "demoJson")
@TypeDefs({
@TypeDef(name = "json", typeClass = JsonStringType.class)
,
@TypeDef(name = "jsonb", typeClass = JsonBinaryType.class)
})
public class DemoJsonEntity implements Serializable {
@Id
@GeneratedValue(strategy = IDENTITY)
@Column(name = "id")
private int dataId;
@Type(type = "jsonb")
@Column(name = "jsonData", columnDefinition = "jsonb")
private String jsonData;
public int getDataId() {
return dataId;
}
public void setDataId(int dataId) {
this.dataId = dataId;
}
public String getJsonData() {
return jsonData;
}
public void setJsonData(String jsonData) {
this.jsonData = jsonData;
}
}
Simple as that. All I needed was this dependency
<dependency>
<groupId>com.vladmihalcea</groupId>
<artifactId>hibernate-types-52</artifactId>
<version>2.9.11</version>
</dependency>
For testing purposes, I attempted to save data like this
public static void main(String arg[]) {
try {
DemoJsonEntity obj = new DemoJsonEntity();
JSONObject jsonObj = new JSONObject();
Map m1 = new LinkedHashMap(2);
m1.put("oldValue", "Active");
m1.put("newValue", "InActive");
jsonObj.put("status", m1);
Map m2 = new LinkedHashMap(2);
m2.put("oldValue", "Test 6");
m2.put("newValue", "Test 6 updated");
jsonObj.put("taskDetails", m2);
obj.setJsonData(jsonObj.toString());
Session session = null;
Transaction tx = null;
try {
session = sf.openSession();
tx = session.beginTransaction();
session.save(obj);
tx.commit();
} catch (Exception e) {
if (tx != null) {
tx.rollback();
}
throw new RuntimeException(e);
} finally {
session.close();
}
} catch (Exception e) {
System.out.println("error: " + e.getMessage());
}
}
Output
https://i.stack.imgur.com/Uzkv6.png