How to use JSONB PostgreSQL to insert columns through JSON?

Question

I have an entity, which is mapped to PostgreSQL, I want to use JSONB to be able to insert columns through JSON.

@Entity
@Table(name="TB_ORDEM_MANUTENCAO")
@TypeDef(
        name = "jsonb",
        typeClass = JsonBinaryType.class
)
public class OrdemManutencao implements Serializable {
private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy=GenerationType.AUTO) // Cria automaticamente os ids
    private long id;

    @JsonFormat(shape=JsonFormat.Shape.STRING, pattern="yyyy-MM-dd")
    private Date dataManutencao;    

    @OneToOne
    @JoinColumn(name = "equipamento_id", unique = true)
    private Equipamento equipamento;

    @Type(type = "jsonb")
    @Column(columnDefinition = "jsonb")
    private String propriedades;            

}

In Swagger, I try to add a Maintenance Order as follows:

{
  "propriedades" : [{"uf": "MG", "teste": "teste"}],
  "dataManutencao": "2020-04-04",
  "equipamento": {
    "id": 13,
    "nome": "Lavadoura",
    "quantidade": 1
  }
}

This does not insert the columns in my order_maintenance table, just insert like that:

Response body
{
  "id": 27,
  "dataManutencao": "2020-04-04",
  "equipamento": {
    "id": 13,
    "nome": "Lavadoura",
    "quantidade": 1
  }
}

how can I do this?

possible duplicate with https://stackoverflow.com/questions/28802544/java-8-localdate-jackson-format — Elarbi Mohamed Aymen, Apr 11 '20 at 22:04
Does this answer your question? [Java 8 LocalDate Jackson format](https://stackoverflow.com/questions/28802544/java-8-localdate-jackson-format) — Elarbi Mohamed Aymen, Apr 11 '20 at 22:04
This gives a clue, maybe, https://thoughts-on-java.org/persist-postgresqls-jsonb-data-type-hibernate/ — , Apr 12 '20 at 13:22

score 0 · Accepted Answer · answered Apr 12 '20 at 20:29

0

This solve to me: vladmihalcea.com/map-string-jpa-property-json-column-hibernate.

answered Apr 12 '20 at 20:29

Skinper

73
8

How to use JSONB PostgreSQL to insert columns through JSON?

1 Answers1