aspose file tools*
The moose likes JDBC and the fly likes storing images in database and retreiving it Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "storing images in database and retreiving it" Watch "storing images in database and retreiving it" New topic
Author

storing images in database and retreiving it

salamath ahamed
Greenhorn

Joined: Aug 11, 2003
Posts: 7
hello
how to store an image in database and how to retrieive it ,please help


salamath
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
There are two approaches:
1) Store the image file into a BLOB field
2) Keep the image in the filesystem and only store the location into the database


Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

My Opinion. Go with Lasse's 2nd option of storing the image on the file system and storing the location in the database. DB Performance can really decrease when storing Binary data in a table.
However, if you would prefer to store the image itself in the database...

I don't know if this is syntactically correct. But in escense I believe the thoery is correct. I just kind of threw this together.


GenRocket - Experts at Building Test Data
 
Consider Paul's rocket mass heater.
 
subject: storing images in database and retreiving it