How to convert Json object to BLOB in java

Question

I need to store HTTP REST API (POST, GET, PATCH, etc.) requests and responses into a database entry (Column as BLOB), so that we can audit the requests and responses later.

As part of the incoming HTTP POST request, the DTO object is coming as request body. I can extract the JSON object as a request body.

How can I convert that JSON object to BLOB in Java?

This question already has an answer stackoverflow.com/questions/7947871/… and stackoverflow.com/questions/36560223/… — gbenga wale
– gbenga wale, Commented Jun 17, 2017 at 21:34
This question is the same as stackoverflow.com/questions/17400497/… — tima
– tima, Commented Jun 18, 2017 at 2:20
@gbengawale He's asking for BLOB. Both your suggestions have nothing to do with blob. — Teddy
– Teddy, Commented Aug 11, 2022 at 5:58

Thangamudy Gurusamy · Accepted Answer · 2017-06-22 08:47:32Z

0

Try this

String str = json.toString();
PreparedStatement ps1 = conn.prepareStatement("update table set blob=? where id=1");
Blob blob = conn.createBlob();
blob.setBytes(1, str.getBytes());
ps1.setBlob(1, blob);
ps1.executeUpdate();

answered Jun 22, 2017 at 8:47

Thangamudy Gurusamy

912 bronze badges

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

Collectives™ on Stack Overflow

How to convert Json object to BLOB in java

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