Storing images in MySQL database

[niku shah]

Hi

I am developing Shopping cart , in that clients can also sell their products.

For that purpose products images is to be stored .....

can anybody tell how cani do this ?

well i m using Tomcat , Servlets and MySql DBMS......

Thanks

[Scott Selikoff]

It's not a good practice to put images in a database because they can be quite large but if you must, lookup info about blobs/clobs.

[anand phulwani]

Hi Niku,

Set The Image Field in MuSQL To Blob type,and then

File image = new File("itsmyphoto.jpg");
FileInputStream fis = new FileInputStream( image );
 
ps.setBinaryStream( 3, fis, ( int )image.length() );

[niku shah]

Thanks anand but there is no effect in MySQL database after executing the statement.... ps.setBinaryStream....

if you know how to store image (jpg)file in tomcat's image folder and just path in database columns please let me know...

[Paul Clapham]

Originally posted by niku shah:
Thanks anand but there is no effect in MySQL database after executing the statement.... ps.setBinaryStream....

Of course there isn't. Just as there would be no effect on the database after executing ps.setString(1, "test"). You have to follow that by executing the PreparedStatement in the usual way.

[anand phulwani]

Here's an example of it,
Hope that would be useful.
The Link