Save and Retrieve Image from MySql Database Using Java

Here you will get an example for save and retrieve image from MySql database using Java.

In development we generally use folders for managing images. But we can store images directly in database using BLOB (Binary Large Object) data type.

MySql has following blob types:

TINYBLOB: 255 bytes




Save and Retrieve Image from MySql Database Using Java

Depending upon requirement we can use any type. It is recommend no to use database for storing images with large size because it will increase the database size.

Below I have given an example of how to store and retrieve images from database. The description for table that I used is given below.

Table Details


Save and Retrieve Image from MySql Database Using Java

How to Save Image in Database


Above example will take image from location E:\\image.png and save it into database table. Actually you can’t see the image directly in the table. You have to retrieve it from database and then save it to some location. Below example shows how you can do this.


How to Retrieve Image from Database


Above example will fetch image from database and save it at location E:\\image1.png.

Comment below if you facing difficulty to understand above code.

Happy Coding!! 🙂 🙂

25 thoughts on “Save and Retrieve Image from MySql Database Using Java

  1. Solai

    Hi Neeraj,

    I need how to download the image in database table and the image is stored in server location.
    i am using spring and hibernate framework.

  2. Gator

    what would i need to change to retrieve to a jlabel in swing form?
    this is driving me crazy…

    1. Admin Post author

      After getting the image in byte from database add following lines.

      Image img = Toolkit.getDefaultToolkit().createImage(image);
      ImageIcon icon = new ImageIcon(img);
      JLabel lPhoto = new JLabel();

      Here image is of byte type. I hope this will help.

      1. darmawan

        I’ve tried the way you and I do not get the error. but I also don’t get the image from a database

  3. anmol

    “pos” + “length” arguments can not be larger than the BLOB’s length.
    above is an SqlException coming when i tried to retrieve an image .

    1. Admin Post author

      The maximum length of Blob type is 64kb, you are trying to retrieve an image which is greater than 64kb. Use bigger types like mediumblob or longblob.

  4. Karan

    I want to download blob data for 5800K records and avg size of one blob is 2kb so total data would be 11 tb approx.

  5. shreya soni

    how to retrieve the image along with some data from database using only java

  6. Roma

    Am successful triving an image, but it’s coming with 0 kb, that course not to open, can you help me with that…

  7. Abid

    How I can retrieve image from mysql database through its path not of blob datatype

  8. Suyamburaja

    how to upload the file and same file will be download in sql with java . i need a coding

  9. Naveed

    how we can retrieve image from mysql database to print in jTable please guide me.

  10. Gaurav

    sir please help me I want to insert a passport size photo in netbeans jforms from user and their fingerprint also by using fingerprint scanner device so please help me …
    plz give me idea and way to code this problem..and sir can you tell me that where I can learn all about these classes and how to use them form internet ..

  11. bnhs

    will this code fetch all images /files from database ? How to achieve download all files ?

  12. prince kumar

    After retrieving image from database i am getting image but image size is 0 kb and getting error could not open .

  13. Alabi Razaq

    how can i carry out a CRUD operation with an image field using DAO and MVC patterns with JSTL.
    i’ve tried using your example but i run into problem when it comes to converting blob to string and vice versa.

  14. Ranjith

    once the image is retrieved from database is it possible to use that image in tag in jsp…

  15. Shekhar Sahu

    Is there any equivalent class like java.sql.Blob for MEDIUMBLOB?

  16. hamza tanveer

    Can You Please do the same image saving thing without using PreparedStatement method.

  17. manasa

    image is not retriving from the databse. In jsp file it is image column showing null


Leave a Reply

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