how to store PostgreSQL jsonb using SpringBoot + JPA?

by

Tried this but understood nothing!

To fully work with jsonb in Spring Data JPA (Hibernate) project with Vlad Mihalcea’s hibernate-types lib you should just do the following:

1) Add this lib to your project:

<dependency>
    <groupId>com.vladmihalcea</groupId>
    <artifactId>hibernate-types-52</artifactId>
    <version>2.2.2</version>
</dependency>

2) Then use its types in your entities, for example:

@Data
@NoArgsConstructor
@Entity
@Table(name = "parents")
@TypeDef(name = "jsonb", typeClass = JsonBinaryType.class)
public class Parent implements Serializable {

    @Id
    @GeneratedValue(strategy = SEQUENCE)
    private Integer id;

    @Column(length = 32, nullable = false)
    private String name;

    @Type(type = "jsonb")
    @Column(columnDefinition = "jsonb")
    private List<Child> children;

    @Type(type = "jsonb")
    @Column(columnDefinition = "jsonb")
    private Bio bio;

    public Parent(String name, List children, Bio bio) {
        this.name = name;
        this.children = children;
        this.bio = bio;
    }
}

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Child implements Serializable {
    private String name;
}

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Bio implements Serializable {
    private String text;
}

Then you will be able to use, for example, a simple JpaRepository to work with your objects:

public interface ParentRepo extends JpaRepository<Parent, Integer> {
}

parentRepo.save(new Parent(
                     "parent1", 
                     asList(new Child("child1"), new Child("child2")), 
                     new Bio("bio1")
                )
);

Parent result = parentRepo.findById(1);
List<Child> children = result.getChildren();
Bio bio = result.getBio();

More Related Contents:

  1. How to escape question mark (?) character with Spring JpaRepository
  2. How to perform update operations on columns of type JSONB in Postgres 9.4
  3. Postgresql query array of objects in JSONB field
  4. How to work with PGpoint for Geolocation using PostgreSQL?
  5. PostgreSQL jsonb, `?` and JDBC
  6. Spring Docker container cannot access Postgres Docker container
  7. How to reset postgres’ primary key sequence when it falls out of sync?
  8. How to import CSV file data into a PostgreSQL table
  9. The forgotten assignment operator “=” and the commonplace “:=”
  10. Index for finding an element in a JSON array
  11. Equivalent to unpivot() in PostgreSQL
  12. Passing user id to PostgreSQL triggers
  13. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  14. Do nullable columns occupy additional space in PostgreSQL?
  15. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  16. Disable PostgreSQL foreign key checks for migrations
  17. Prevent recursive trigger in PostgreSQL
  18. serial in postgres is being increased even though I added on conflict do nothing
  19. PostgreSQL Error: Relation already exists
  20. How to make a select with array contains value clause in psql
  21. Using row_to_json() with nested joins
  22. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  23. Sorting array elements
  24. pgAdmin III Why query results are shortened?
  25. How to add a conditional unique index on PostgreSQL
  26. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  27. input file appears to be a text format dump. Please use psql
  28. Hashing a String to a Numeric Value in PostgreSQL
  29. Best way of handling entities inheritance in Spring Data JPA
  30. Format specifier for integer variables in format() for EXECUTE?

Leave a Comment