How to save @Lob data from spring in to a Postgres database?

Question

I want to save an encoded image in to a Postgres database using the @Lob annotation in Spring. There are no errors when I test the application, I browse an image and then save it. But when I open the database instead of the base64 encoded image in the image column I just have a couple of numbers (41417, 41418 and so on).

Here is a part of the code from my class.

public class Product {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;

@NotNull
private String name;

@Lob
private String imageBase64;

Here is the function I use to save the object in to the database.

public Product saveProduct(Product product, MultipartFile image) throws IOException {
    if (image != null && !image.getName().isEmpty()) {
        byte[] bytes = image.getBytes();
        String base64Image = String.format("data:%s;base64,%s", image.getContentType(), Base64.getEncoder().encodeToString(bytes));
        product.setImageBase64(base64Image);
    }
    return this.productRepository.save(product);
}

But when it saves it in to the database it looks like this (column image_base64).

Jacob G. · Accepted Answer · 2020-08-15 22:58:08Z

4

Your @Lob did save correctly. The value that you see (41417) represents its OID.

To see the contents of the large object, you can use Postgres' lo_get function (assuming you're using version 9.4+):

SELECT lo_get(cast(image_base64 as bigint)) FROM products WHERE id = 1;

answered Aug 15, 2020 at 22:58

Jacob G.

29.8k7 gold badges70 silver badges122 bronze badges

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

Collectives™ on Stack Overflow

How to save @Lob data from spring in to a Postgres database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related