Insert into MySQL DB an image from an http URL

[Robert Insanovation White]

I want to insert an image from an URL, directly into the database.

The problem is that when I open the image in Workbench, after it's insertion, it doesn't get displayed. Can you tell me please, is it something wrong with this code? Except the OOP syntax.
The field for the image in the DB is Medium Blob.

public class InsertPictureToMySql {
  public static void main(String[] args) throws Exception, IOException, SQLException {
    Class.forName("org.gjt.mm.mysql.Driver");
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/xxx", "xxx", "xxx");
    String INSERT_PICTURE = "insert into MyPictures(id, name, photo) values (?, ?, ?)";

    FileInputStream fis = null;
    PreparedStatement ps = null;
   
      conn.setAutoCommit(false);
      URL file = new URL("http://www.mountainprofessor.com/images/Mountain-Ranges-Colorado-2.jpg");
      URLConnection urlConnection = file.openConnection();
      ps = conn.prepareStatement(INSERT_PICTURE);
      ps.setString(1, "001");
      ps.setString(2, "name");
      ps.setBinaryStream(3, urlConnection.getInputStream());
      ps.executeUpdate();
      conn.commit();
    
  }

}

[Paul Clapham]

Have you been able to get Workbench to display images which came from other sources, or which you put into the database in different ways? If so then it would be useful to compare what you did here with what you did which worked.

[Robert Insanovation White]

Well, Workbench will display the images from other databases. And a weird fact: if I click to open a field of text format, in the same table, it will open it; then, I click to open the image, it opens it, but in the "Image" tab, it displays nothing... though the Binary is displayed.

[Paul Clapham]

So... you have no evidence that Workbench knows how to display images which are stored in MySQL?

Have you considered modifying your code to use one of the databases which Workbench does know how to display images from?

[Robert Insanovation White]

Yep, It's just weird for me. It's 4 AM by my local time and I'm tired... can't go to bed because of this.

But, does the code seem correct?

[Robert Insanovation White]

Nevermind, I solved it. Hooray.

[Rob Spoor]

Would you like to tell us how? Others could learn from it.

[Robert Insanovation White]

By solving I meant more like clarifying if the picture managed to be inserted in the DB. I checked if the picture was inserted, by querying the DB, retrieving the blob and storing it in a local file. Yes, the pictures were inserted, the entire time.

The question is: if I understood why Workbench didn't show the picture in the "Image" tab? Nope.

[Paul Clapham]

I don't know anything about your Workbench, but it seems to me it would have to know that a set of bytes in a database column represented an image (and not, say, a Microsoft Word document or a serialized Java object). That's why I tried to suggest that you should look at how it worked with other databases. Maybe there's a configuration file somewhere where you tell it that column ABC contains JPG images? Maybe you have to use a particular column definition not supported in MySQL? Or you just used the wrong type of column? The possibilities are endless.

[Robert Insanovation White]

Thank's for the various ideas, it gave me an image for the future experiences.