当项目同时使用MySQL和PostgreSQL时，从JsonStringType切换为JsonBinaryType [英] Switch from JsonStringType to JsonBinaryType when the project uses both MySQL and PostgreSQL

问题描述

当需要从PostgreSQL切换到MariaDB/MySql时，列json出现问题.
我使用Spring Boot + JPA + Hibernate + hibernate-types-52.
我要映射的表是这样的:

I have a problem with column json when it's necessary to switching from PostgreSQL to MariaDB/MySql.
I use Spring Boot + JPA + Hibernate + hibernate-types-52.
The table i want to map is like this:

CREATE TABLE atable(
 ...
 acolumn JSON,
 ... 
);

好，它适用于PostgreSQL和MariaDB/MySql.
问题是当我想部署一个可以轻松地从一个切换到另一个的应用程序时，因为PostgreSQL和MySQL/MariaDB的正确的hibernate-types-52实现是不同的

这适用于MySQL/MariaDB

Ok it works for PostgreSQL and MariaDB/MySql.
The problem is when i want to deploy an application that switch easly from one to another because the correct hibernate-types-52 implementation for PostgreSQL and MySQL/MariaDB are different

This works on MySQL/MariaDB

@Entity
@Table(name = "atable")
@TypeDef(name = "json", typeClass = JsonStringType.class)
  public class Atable {
  ...
  @Type(type = "json")
  @Column(name = "acolumn", columnDefinition = "json")
  private JsonNode acolumn;
  ...
}

这适用于PosgreSQL

This works on PosgreSQL

@Entity
@Table(name = "atable")
@TypeDef(name = "json", typeClass = JsonBinaryType.class)
public class Atable {
  ...
  @Type(type = "json")
  @Column(name = "acolumn", columnDefinition = "json")
  private JsonNode acolumn;
  ...
}

任何一种从JsonBinaryType切换到JsonStringType的解决方案(或解决此问题的任何其他解决方案)都是值得的.

Any kind of solutions to switch from JsonBinaryType to JsonStringType (or any other solution to solve this) is appreciated.

推荐答案

从Hibernate Types项目的 2.11.0 版本开始，您只需使用 JsonType ，可与PostgreSQL，MySQL，Oracle，SQL Server或H2配合使用.

Starting with the 2.11.0 version of the Hibernate Types project, you can just use the JsonType, which works with PostgreSQL, MySQL, Oracle, SQL Server, or H2.

因此，请使用 JsonType 代替 JsonBinaryType 或 JsonStringType

@Entity
@Table(name = "atable")
@TypeDef(name = "json", typeClass = JsonType.class)
public class Atable {

  @Type(type = "json")
  @Column(name = "acolumn", columnDefinition = "json")
  private JsonNode acolumn;

}

就是这样！

这篇关于当项目同时使用MySQL和PostgreSQL时，从JsonStringType切换为JsonBinaryType的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！