How to store JSON object into PostgreSQL using JSONB data type inside table and PostgreSQL JDBC driver

Question

I want to save following json object into PostgreSQL db table as jsonb

{
  "fname":"john",
  "lname:"doe",
}

I am currenlty using PGObject to create object and set type to jsonb and pass value as json string

Looking for a better approach with micronaut-data and micronaut Is there any native data type supported in micronaut-data to convert the Java object to JSON and store in db? How to save the data using postgres jdbc driver

typecasting in query using :jsonb is already tried with raw jdbc if it works with micronaut-data / predator how to do it?

Swanand Keskar · Accepted Answer · 2019-08-28 07:06:46Z

11

We can use PGObject and Jackson Object mapper to save the json in Postgres

val person=PGobject()
person.type="jsonb"
person.value=ObjectMapper.writeValueAsString("{"fname":"john","lname":"doe"}")

now person object can be passed to JDBC driver for storing data as jsonb

answered Aug 28, 2019 at 7:06

Swanand Keskar

1,0731 gold badge15 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to store JSON object into PostgreSQL using JSONB data type inside table and PostgreSQL JDBC driver

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related