how to store JSON in POSTGRES using SpringBoot + JPA?

Question

I have a payload that am trying to save into a database, whenever I post the payload, it returns the mapped JSON objects as null instead of the values in the payload passed.

here is the JSON payload

{
    "authStatus": {
        "authStatusCode": 131,
        "authStatusDescription": "API call doesn't need authentication"
    },
    "results": {
        "beepTransactionID": 10764659,
        "payerTransactionID": "5f51eed7347a7",
        "statusCode": "188",
        "statusDescription": "Response was received"
    }
}

after posting it to postman

{
    "id": 14,
    "authStatusCode": null,
    "authStatusDescription": null,
    "beepTransactionID": null,
    "payerTransactionID": null,
    "statusCode": null,
    "statusDescription": null
}

my controller for posting

     @PostMapping("/payload")
        public Payload createPayload(@Valid @RequestBody Payload payload) {
            return payloadRepository.save(payload);
        }

my model

@Entity
@Table(name = "payload", schema = "public")
    public class Payload {
        private long id;
        Integer authStatusCode;
        String authStatusDescription;
        Integer beepTransactionID;
        String payerTransactionID;
        String statusCode;
        String statusDescription;
    
        public Payload(){
    
        }
    
    //getters and setters

Are you having three tables one for payload, one for Authstatus and another for results or else its just the same — venkat
– venkat, Commented Feb 12, 2021 at 6:36

Yassin Hajaj · Accepted Answer · 2021-02-11 21:58:29Z

2

You need intermediary objects, Payload needs to be a bit deeper to match exactly the format of your JSON object

public class Payload {
    AuthStatus authStatus;
    Results results;
    // Add boilerplate code here
}

public class AuthStatus {
    Integer authStatusCode;
    String authStatusDescription;
    // Add boilerplate code here
}

public class Results {
    Integer beepTransactionID;
    String payerTransactionID;
    String statusCode;
    String statusDescription;
    // Add boilerplate code here
}

edited Feb 11, 2021 at 21:58

answered Feb 11, 2021 at 21:50

Yassin Hajaj

22.1k10 gold badges60 silver badges93 bronze badges

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

6 Comments

Raymond Mumo Over a year ago

Hi @Yassin and where do I set the getters and setters for the above and how do I call save?

Yassin Hajaj Over a year ago

Raymond, add the getters and setters yourself no problem with that. The saving mechanism remains the same.

Raymond Mumo Over a year ago

public class AuthStatus and public class Results are complaining that I dnt make them public, if they are public they are throwing an error

Yassin Hajaj Over a year ago

Create them in their own file

Raymond Mumo Over a year ago

Which class will have the entity annotation and table name? And which one will house the primary id?

|

D_J · Accepted Answer · 2021-02-12 05:45:31Z

0

Try using

@Type(type = "jsonb")
@Column(columnDefinition = "jsonb")

to store payload into JsonNode format as it is

answered Feb 12, 2021 at 5:45

D_J

652 silver badges10 bronze badges

1 Comment

Raymond Mumo Over a year ago

hi @dhiraj, I want to extract the specific values from the json string and insert to columns ands rows, not the entire json

Collectives™ on Stack Overflow

how to store JSON in POSTGRES using SpringBoot + JPA?

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related