Now I learn about nested jsons and geojson and how to save them in PostgreSQL as JsonB directly in database and before starting. Inspiration source: https://thorben-janssen.com/persist-postgresqls-jsonb-data-type-hibernate/ Error I get when running the app: Here is the Main Entity: Here is the geojson(nested json) I want to save as Jsonb in a column in database: Here is the implementation of Usertype
Tag: jsonb
How to update a JSONB column in PostgreSQL using a Spring Data JPA Query
I have the following Controller If i remove/comment That is i don’t add the fetched result to the new updatedAdditionDetails (of type ArrayList), the DB updates successfully Otherwise i get the below error : ERROR: column “itemsinventory_addtion_details” is of type jsonb but expression is of type recordn Hint: You will need to rewrite or cast the expression.n Position In my