Save image in DB with entity

Question

I created an entity. I want to write a RestController to save this entity and an image in MySQL. I use Java8, SpringBoot, Hibernate, Rest API, JSON. How can I do it? Can I save it together?

public class Client{

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    private Long id;

    @Column(name = "firstName")
    private String firstName;

    @Column(name = "lastName")
    private String lastName;

    @Column(name = "photo")
    private String photo;
}

Controller

@PostMapping(value = "/save/client")
    public ResponseEntity saveClient(@RequestBody @Valid Client client){
        ResponseEntity responseEntity = new ResponseEntity<>(HttpStatus.NOT_FOUND);
        if(Objects.nonNull(client)){
            this.clientService.saveClient(client);
            responseEntity = new ResponseEntity<>(HttpStatus.OK);
        }
        return responseEntity;
    }

Kelvin Ikome · Accepted Answer · 2018-11-28 13:07:35Z

0

You can achieve that using JPA/Hibernate.

Create a repository interface which extends either CrudRepository or JpaRepository.
Autowire an instance of the repository interface
Save/store entity in the database by making a call to the save() method of the repository interface.

Take a look at the following article on how to use JPA/Hibernate: https://spring.io/blog/2011/02/10/getting-started-with-spring-data-jpa/

answered Nov 28, 2018 at 13:07

Kelvin Ikome

242 bronze badges

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

Comments

George Artemiou · Accepted Answer · 2018-11-28 13:51:03Z

0

Since you are using Hibernate, you can do something like this below, let me know if you have any problems.

@Lob
@Column(name = "content")
private byte[] content;

@JsonSetter("content")
public void setContent(String content) {
  this.content = Base64.decode(content.getBytes("UTF-8"));
}

public byte[] getContent() {
  return content;
}

edited Nov 28, 2018 at 13:51

answered Nov 28, 2018 at 13:04

George Artemiou

3,1962 gold badges21 silver badges38 bronze badges

6 Comments

user9680767 Over a year ago

Thank you! I corrected my entity. I am trying to send post by the postman. { "firstName": "Four", "lastName": "Borov" } Also, I added an image file in form-data. But I see "rg.springframework.web.HttpMediaTypeNotSupportedException: Content type 'application/x-www-form-urlencoded;charset=UTF-8' not supported"

user9680767 Over a year ago

I solved it. But My entity saved without the image. In DB i see null

George Artemiou Over a year ago

You need to serialise your entity and also have the @JsonSetter("content") on top of the setter, can you try that?

user9680767 Over a year ago

I added this annotation and implements Serializable. But it didn't help. Or I need to serialise my entity another way?

George Artemiou Over a year ago

Can you please update your answer to reflect your changes? Also what is your table structure? Where does it fall through, did you try debugging to see where the problem is?

|

Collectives™ on Stack Overflow

Save image in DB with entity

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related