Spring Data JPA與PostgreSQL的jsonb類型集成與支持

private final ObjectMapper mapper = new ObjectMapper;;

@Override
public void nullSafeSet(PreparedStatement st, Object value, int index, SessionImplementor session) throws HibernateException, SQLException {
if (value == null) {
st.setNull(index, Types.OTHER);
} else {
try{
st.setObject(index, mapper.writeValueAsString(value), Types.OTHER);
}catch (IOException e){
e.printStackTrace;
}

}
}

@Override
public Object deepCopy(Object originalValue) throws HibernateException {
if (originalValue != null) {
try {
return mapper.readValue(mapper.writeValueAsString(originalValue),
returnedClass);
} catch (IOException e) {
throw new HibernateException("Failed to deep copy object", e);
}
}
return null;
}

@Override
public Object nullSafeGet(ResultSet rs, String[] names, SessionImplementor session, Object owner) throws HibernateException, SQLException {
PGobject o = (PGobject) rs.getObject(names[0]);
if (o.getValue != null) {
try {
return mapper.readValue(o.getValue,Map.class);

}catch (IOException e){
e.printStackTrace;
}
}

return new HashMap;
}

@Override
public Serializable disassemble(Object value) throws HibernateException {
Object copy = deepCopy(value);

if (copy instanceof Serializable) {
return (Serializable) copy;
}

throw new SerializationException(String.format("Cannot serialize "%s", %s is not Serializable.", value, value.getClass), null);
}

@Override
public Object assemble(Serializable cached, Object owner) throws HibernateException {
return deepCopy(cached);
}

@Override
public Object replace(Object original, Object target, Object owner) throws HibernateException {
return deepCopy(original);
}

@Override
public boolean isMutable {
return true;
}

@Override
public int hashCode(Object x) throws HibernateException {
if (x == null) {
return 0;
}

return x.hashCode;
}

@Override
public boolean equals(Object x, Object y) throws HibernateException {
return ObjectUtils.nullSafeEquals(x, y);
}

@Override
public Class returnedClass {
return Map.class;
}

@Override
public int sqlTypes {
return new int{Types.JAVA_OBJECT};
}

@Column(columnDefinition = "jsonb")
@Type(type = "JsonbType")
private Map info;
}

for(Object entry :returnMap.entrySet){
log.info(entry.toString);
}
};
}