how to store image in MS SQL Server

hi friends,
I want to store images (.jpg or .png or .gif) in MS SQL Server 2005 database using JDBC-ODBC connectivity in servlet. can anybody give me step by step procedure to do it.
I don't wan't to store the reference to images, instead i want to store actual image file in a database.

Please give me step by step procedure to do it.

Thank You

Have you tried anything yourself? What do you think the step-by-step procedures should be?

Please take the time to choose the correct forum for your posts. This forum is for questions on Servlets, not JDBC. For more information, please read this.

This post has been moved to a more appropriate forum.

Lokendra Shekhawat wrote:Please give me step by step procedure to do it.

You'll want to read up on BLOBs in the JDBC tutorial.

i am using the following code for storing image in ms sql server 05

i have wriiteen the following sql script

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author Newton
 */
public class sqlups extends HttpServlet {
   
    @Override
    public  void service(HttpServletRequest req,HttpServletResponse res)throws IOException,ServletException
    {
        PrintWriter out=res.getWriter();
        out.println("loads");
    String ure="jdbc:odbc:Circuit";
    Connection cnu=null;
    String pic="INSERT INTO Images VALUES(?)";
    
     File f=new File("D://124744.jpg");
        FileInputStream in=new FileInputStream(f);
        byte [] b=new byte[(int)f.length()];
       in.read(b);
        out.println("going inside try");
     try
        {
        out.println("bewlow class fornam");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

out.println("bewlow get connec");

cnu=DriverManager.getConnection(ure,"sa","sha");

out.println("bewlow prepare stmt");

PreparedStatement pst=cnu.prepareStatement(pic);

out.println("set pamam");

pst.setBytes(1, b);

out.println("below is ecev");

int n=pst.executeUpdate();

pst.close();

out.println("close");
          
        }
        catch(Exception eds)
        {
        out.println(eds+"");
        }
    }
}

but when executed it shows this exception

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '�'.
please help !

I am also getting the same error. aren't there any way around it. can't we store image on the database at all???

ya i think the same there is no way to store images in sql server

using servlet
so i gonna change the idea now i am going to give the clients selective images only already uploaded on server..

bye with some

(cry and pain)
wait wait
i also downloaded "jtds-1.2.3-dist" driver for sql server but the same problem occured now i think its a problem of ODBC or the ms sql server

loks checkout here : http://www.java.happycodings.com/JDBC/code3.html

It's probably not the source of the problem, but one thing you need to fix is the following code: ReadDoesntDoWhatYouThinkItDoes

File f=new File("D://124744.jpg");
FileInputStream in=new FileInputStream(f);
byte [] b=new byte[(int)f.length()];
in.read(b);

String pic="INSERT INTO Images VALUES(?)";

The above live Image as Table name ,but its entity or column is not mentioned like "INSERT INTO Images(ColumnName) VALUES(?)"; which is main requirement so makes exception ..

Welcome to the Ranch!

It's not required to add the column names; if you omit them it's equivalent to adding all column names. In this case there is only one column so there is no need to specify the column name.