This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes how to save image to mysql? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to save image to mysql?" Watch "how to save image to mysql?" New topic

how to save image to mysql?

yub huang

Joined: Jun 08, 2002
Posts: 17
hi,i use mysql database, and i want to save an image to the database using JDBC.Should i set the data type as blob? i know getting the image from the database use ResultSet.getBinaryStream(),but i don't know how to save it to the database.who can tell what to do?
please help!
thanks you!!!

I want to know
Andres Gonzalez
Ranch Hand

Joined: Nov 27, 2001
Posts: 1561
This question is asked many times in this forum. I'd recommend you typing "image" in the search facility, you'll get good results.

I'm not going to be a Rock Star. I'm going to be a LEGEND! --Freddie Mercury
yub huang

Joined: Jun 08, 2002
Posts: 17
thanks Andres Gonzalez!!
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

On a side note, it is my opinion that saving images in a database is not the best idea unless that is your only option. I will typically create an entry in the database as to a location on the hard drive of the image. You will maintain better performance on your Tables if you do it this way.

GenRocket - Experts at Building Test Data
yub huang

Joined: Jun 08, 2002
Posts: 17
hi,Gregg Bolinger,why do you think saving images in a database was not the best idea? if i have 10,000 images,and some images files name were the same, can you tell me what you will do?
Dana Hanna
Ranch Hand

Joined: Feb 28, 2003
Posts: 227
A good file system alternative would not use the true filename as the filename on the file system. It would use a unique ID as the filename on the hard-drive, and store the real filename in a table... EX - table name "IMAGES" columns "ID" and "FILENAME".
However, this is only good when the image only needs to be read by code residing on the server. If you are writing client/server with swing or something - it woun't be able to use it as a file. You'd have to setup shares, or some type of stream to the client. If this is the case, I'd store it in the DB.
I agree. Here's the link:
subject: how to save image to mysql?
jQuery in Action, 3rd edition