SpringJPA – save/retrieve Files/Images to MySQL database with @Lob annotation

In the tutorial, JavaSampleApproach will show you how to create a SpringBoot project that uses SpringJpa with @Lob annotation to save Files/Images to MySQL database.

I. Technologies

– Java 1.8
– Maven 3.6.1
– Spring Tool Suite – Version 3.9.0.RELEASE
– MySQL
– Spring Boot – 1.5.9.RELEASE

II. Goal

– We create a SpringBoot project to save files/images to MySQL database as below structure:

Spring JPA saves Files-Images to MySQL server - project structure

Create MySQL table:

Spring JPA saves Files-Images to MySQL server - mysql structure

-> Run and check results:

Spring JPA saves Files-Images to MySQL server - mysql results

Spring JPA saves Files-Images to MySQL server - retrieve files results

III. Practice

Step to do:
– Create SpringBoot project
– Create data model
– Create JPA Repository
– Implement Client to save/retrieve files/images
– Configure JPA connection & MySQL script

1. Create SpringBoot project

Using SpringToolSuite to create a SpringBoot project with dependencies:

2. Create data model

3. Create JPA Repository

4. Implement Client to save/retrieve files/images

Implement code to save/retrieve files/images from MySQL database via SpringJPA repository:

5. Configure JPA connection & MySQL script
5.1 Configure connection info

– Open application.properties file, add connection info:

5.2 MySQL script

– Implement MySQL creating table script:

IV. Sourcecode

SpringJpaSaveImage2MySql

By grokonez | December 3, 2017.



Related Posts


2 thoughts on “SpringJPA – save/retrieve Files/Images to MySQL database with @Lob annotation”

  1. Hello
    I would like to build a SpringBoot and angular6 application to record images in a remote database.
    my difficulty is i do not know how to load an image with angular6 and then save this image or this file with springBoot
    thank you for giving me an example illustrating this approach
    thanks again

Got Something To Say:

Your email address will not be published. Required fields are marked *

*