Storing images in MySQL using Java

Question

I want to store images into MySQL databases using a Java applet or at run time user will load the images.

How can I do this?

Please help me out. Is it required to have any special Java-based MySQL or will MySQL simplyl do this thing of loading BLOB image content? If possible, give me code example and mention how I should load MySQL onto my computer for this purpose.

After doing this I want to display that images from mysql onto webpage.

Is that really possible?

How to do it?

Here is some sample code:coderanch.com/t/355553/JDBC/java/… — kosa
– kosa, Commented Dec 29, 2011 at 4:06
You want us to tell you how to install MySQL on top of everything else? That's pretty absurd. — Josh Smith
– Josh Smith, Commented Dec 29, 2011 at 4:11
@Josh - I know how to load simple mysql but don't know whether it will work for blob object. Is there any java specific mysql or simple mysql will work? — user1120418
– user1120418, Commented Dec 29, 2011 at 5:48

Josh Smith · Accepted Answer · 2011-12-29 04:06:50Z

6

You should not store images in MySQL. MySQL is not designed to store BLOBs and will take severe performance hits if you do so.

You can and should store pointers to images, either on your local fileserver or a remote server (like Amazon S3).

If you really want to do this despite my warnings, you can find some sample code here, though the self-same warnings are discussed thoroughly there.

answered Dec 29, 2011 at 4:06

Josh Smith

15.1k19 gold badges74 silver badges126 bronze badges

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

4 Comments

Alfabravo Over a year ago

That comments about restrictions and BLOBs in coderanch are up to 2002. Does that BLOB problem stand in MySQL? I ask because I already worked with an app bringing binaries, setting them in a temp folder and displaying those images with no particular problem in the expected performance. I think it depends on concurrence, expected database growth and so

Josh Smith Over a year ago

@Alfabravo The performance issues still remain. Regardless, it would constitute poor architecture. As the system scales, you'd probably like to do some sort of dynamic resizing and loading, going to your business logic for looking up images and not the database itself. A consistent image-naming schema would be enough to have your image presentation be a mixture of business logic and an HTTP request. That's vastly preferable to storing BLOBs in a DB.

Alfabravo Over a year ago

I tend to agree after some odd experiences with images submitted thru oracle forms to oracle DB being transformed to bitmaps, increasing their size by 10x. A secure-and-properly-configured filesystem is always better than some emulation in a DBMS. Just wanted to know about this certain case :)

MiB Over a year ago

You could also do both, i e store the image in the database as a blob, but routinely write them out once stored to image file directories and store the path. When you request the image, you serve the image on disc from the path. In your database you have a backup of each image and these are saved trough normal db backup. They can also be restored quickly at a new server to a different path, if needed. Of course, you'd have to make sure the image is not mangled when stored. In my experience, it's not.

Sunil Kumar Sahoo · Accepted Answer · 2011-12-29 05:22:07Z

0

you can use setBinaryStream() in java to store images to blob data type column of mysql

File image = new File("C:/image.jpg");
PrepareStatement psmnt = connection.prepareStatement
("insert into save_image(image) "+ "values(?)");

FileInputStream fis = new FileInputStream(image);
psmnt.setBinaryStream(3, (InputStream)fis, (int)(image.length()));
/* executeUpdate() method execute specified sql query. Here this query 
insert data and image  */ 
int s = psmnt.executeUpdate();

See below tutorial How to insert Image in MySQL using Java Program

answered Dec 29, 2011 at 5:22

Sunil Kumar Sahoo

53.7k55 gold badges182 silver badges244 bronze badges

Comments

Jay · Accepted Answer · 2016-10-12 07:38:37Z

0

As Josh Smith suggested you should not store images using a BLOB or a LONGBLOB in MySQL. Because it effects drastically on you performance you can do it by following this method. Instead of storing images directly into database, store the image location in the database. As we compare both options, storing images in the database is safe for security purpose. Disadvantage are

If database is corrupted, no way to retrieve.
Retrieving image files from db is slow when compare to other option.

Storing image file location in db will have following advantages.

It is easy to retrieve.
If more than one images are stored, we can easily retrieve image information.

answered Oct 12, 2016 at 7:38

Jay

131 silver badge6 bronze badges

Comments

Martijn Pieters · Accepted Answer · 2017-09-26 08:06:52Z

0

try {
            File image = new File("C:/honda.jpg");
            inputStream = new FileInputStream(image);
            connection = getConnection();
            statement = connection
                    .prepareStatement("insert into trn_imgs(img_title, img_data) "
                            + "values(?,?)");
            statement.setString(1, "Honda Car");
            statement.setBinaryStream(2, (InputStream) inputStream,
                    (int) (image.length()));

            statement.executeUpdate();
        } catch (FileNotFoundException e) {
            System.out.println("FileNotFoundException: - " + e);
        } catch (SQLException e) {
            System.out.println("SQLException: - " + e);
        }

edited Sep 26, 2017 at 8:06

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

answered Nov 26, 2014 at 12:25

Vicky

9,57317 gold badges74 silver badges91 bronze badges

Collectives™ on Stack Overflow

Storing images in MySQL using Java

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related